05. maj 2000 - 15:33Der er
5 kommentarer og 1 løsning
hjælp til newbee...
Hej Jeg har prøvet at sammenflette min ”Billeddatabase” med ”Paging af et recordset” Problemet er at den ny side viser alle posterne på alle siderne Er der en som kan se hvordan man kan få det til at vikke :-) Da jeg desværre i øjeblikket kan finde ud af klippe / klistre :-(
x.asp:
<% intPage = Request("page") If isNumeric(intPage) = False Or intPage < 1 Then intPage = 1 End If Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "SELECT * FROM Images ORDER BY ID DESC" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("dk.mdb") rs.Open strSQL, strDSN, 1 If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 5 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>" %>
<% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("dk.mdb") strSQL = "Select * From Images ORDER BY ID DESC" Set RS = Conn.Execute(strSQL) %>
<% Do While Not rs.EOF %>
<table border="0" cellpadding="0" cellspacing="4" width="350" bgcolor="#000000" align="center"> <tr> <td rowspan="3" width="35%"><a href="show2img.asp?id=<%= RS("ID")%>"><font size="1"><img src="<%= RS("Thumb")%>" BORDER="0"></font></a></td> <td width="80%"><font size="1"><strong><%= RS("Navn")%></strong></font></td> </tr> <tr> <td width="80%"><font size="1">Oploaded den: <strong><%= RS("Dato")%></strong></font></td> </tr> <tr> <td width="80%"><font size="1">Antal downloads: <strong><%= RS("Antalclick")%></strong></font></td> </tr> </table> <% RS.MoveNext Loop %> <% Do While Not rs.EOF And intRecCount > 0 intRecCount = intRecCount - 1 rs.MoveNext Loop End If rs.Close Set rs = Nothing %> <% Conn.Close Set Conn = Nothing %> <% If Clng(intPage) > 1 Then Response.Write "<font size=-1><a href=x.asp?page=" & intPage - 1 & "> << Forrige side</a>" Else Response.Write "" End If Response.Write " " For intNum = 1 To intPageCount Response.Write "<font size=-1><a href=x.asp?page=" & intNum & ">< " & intNum & " ></a> " Next Response.Write " " If Clng(intPage) < Clng(intPageCount) Then Response.Write "<font size=-1><a href=x.asp?page=" & intPage + 1 & ">Næste side >></a> " Else Response.Write "" End If %>
I dette særtema ser vi på, hvordan cloud og AI bliver fundamentet for virksomhedernes digitale forretning, og hvordan de nye muligheder for automatisering og forretningsværdi kan udnyttes uden at miste overblik, sikkerhed og menneskelig kontrol.
det er disse 2 filer: 1:<% intPage = Request("page") If isNumeric(intPage) = False Or intPage < 1 Then intPage = 1 End If Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "SELECT Navn FROM Images ORDER BY ID DESC" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("dk.mdb") rs.Open strSQL, strDSN, 1 If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 5 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>" Do While Not rs.EOF And intRecCount > 0 Response.Write rs("Navn") & "<br>" intRecCount = intRecCount - 1 rs.MoveNext Loop End If rs.Close Set rs = Nothing Response.Write "<p>Gå til side " For intNum = 1 To intPageCount Response.Write "<a href=x4.asp?page=" & intNum & ">" & intNum & "</a> " Next Response.Write "<p>" If Clng(intPage) > 1 Then Response.Write "<a href=x4.asp?page=" & intPage - 1 & "><<</a>" Else Response.Write "<<" End If Response.Write " " If Clng(intPage) < Clng(intPageCount) Then Response.Write "<a href=x4.asp?page=" & intPage + 1 & ">>></a> " Else Response.Write ">>" End If %>
2: <% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("dk.mdb") strSQL = "Select * From Images ORDER BY ID DESC" Set RS = Conn.Execute(strSQL) %>
<% Set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath ("dk.mdb") strSQL = "Select * From Images ORDER BY ID DESC" Set RS = Conn.Execute(strSQL) %>
nye x.asp ser sådan ud: <% intPage = Request("page") If isNumeric(intPage) = False Or intPage < 1 Then intPage = 1 End If Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "SELECT * FROM Images ORDER BY ID DESC" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("dk.mdb") rs.Open strSQL, strDSN, 1 If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 5 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write "<p><b>Side " & intPage & " af " & intPageCount & "</b></p>" %> <% Do While Not rs.EOF %>
<table border="0" cellpadding="0" cellspacing="4" width="350" align="center"> <tr> <td rowspan="3" width="35%"><a href="show2img.asp?id=<%= RS("ID")%>"><font size="1"><img src="<%= RS("Thumb")%>" BORDER="0"></font></a></td> <td width="80%"><font size="1"><strong><%= RS("Navn")%></strong></font></td> </tr> <tr> <td width="80%"><font size="1">Oploaded den: <strong><%= RS("Dato")%></strong></font></td> </tr> <tr> <td width="80%"><font size="1">Antal downloads: <strong><%= RS("Antalclick")%></strong></font></td> </tr> </table> <% RS.MoveNext Loop %><% Do While Not rs.EOF And intRecCount > 0 intRecCount = intRecCount - 1 rs.MoveNext Loop End If rs.Close Set rs = Nothing %> <% If Clng(intPage) > 1 Then Response.Write "<font size=-1><a href=x4.asp?page=" & intPage - 1 & "> << Forrige side</a>" Else Response.Write "" End If Response.Write " " For intNum = 1 To intPageCount Response.Write "<font size=-1><a href=x4.asp?page=" & intNum & ">< " & intNum & " ></a> " Next Response.Write " " If Clng(intPage) < Clng(intPageCount) Then Response.Write "<font size=-1><a href=x4.asp?page=" & intPage + 1 & ">Næste side >></a> " Else Response.Write "" End If %> men den viser stadig væk alle postene på alle siderne...
jeg fik det at vikke :-) sådan= <% intPage = Request("page") If isNumeric(intPage) = False Or intPage < 1 Then intPage = 1 End If Set rs = Server.CreateObject("ADODB.RecordSet") strSQL = "SELECT * FROM Images ORDER BY ID DESC" strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("dk.mdb") rs.Open strSQL, strDSN, 1 If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 5 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write "<b>Side " & intPage & " af " & intPageCount & "</b>" %><hr> <% Do While Not rs.EOF And intRecCount > 0 %>
<table border="0" cellpadding="0" cellspacing="4" width="350" align="center"> <tr> <td rowspan="3" width="35%"><a href="show2img.asp?id=<%= RS("ID")%>"><font size="1"><img src="<%= RS("Thumb")%>" BORDER="0"></font></a></td> <td width="80%"><font size="1"><strong><%= RS("Navn")%></strong></font></td> </tr> <tr> <td width="80%"><font size="1">Oploaded den: <strong><%= RS("Dato")%></strong></font></td> </tr> <tr> <td width="80%"><font size="1">Antal downloads: <strong><%= RS("Antalclick")%></strong></font></td> </tr> </table> <hr><% intRecCount = intRecCount - 1 RS.MoveNext Loop End If rs.Close Set rs = Nothing %> <div align="center"><% If Clng(intPage) > 1 Then Response.Write "<font size=-1><a href=x4.asp?page=" & intPage - 1 & "> << Forrige</a>" Else Response.Write "" End If Response.Write " " For intNum = 1 To intPageCount Response.Write "<font size=-1><a href=x4.asp?page=" & intNum & ">" & intNum & "</a> " Next Response.Write " " If Clng(intPage) < Clng(intPageCount) Then Response.Write "<font size=-1><a href=x4.asp?page=" & intPage + 1 & ">Næste >></a> " Else Response.Write "" End If %></div>
Synes godt om
Ny brugerNybegynder
Din løsning...
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.