Paging af et recordset
HejJeg har prøvet at omskrive "paging af et recordset" så den virker
på min egne database. Det virker perfekt, lige bortset fra at den bladre
en gang for langt i databasen. Det ser ud som om jeg har en tom post
i databasen, men det er der ikke.
Her er min asp fil :
<html>
<head>
<title>Paging af et recordset</title>
</head>
<body>
<%
Const adOpenKeySet = 1
Const adLockReadOnly = 1
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM nyhed"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("/database/nyheddb.mdb")
rs.Open strSQL, strDSN, adOpenKeySet, adLockReadOnly
If Not (rs.BOF Or rs.EOF) Then
rs.PageSize = 1
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("Refnr") & "<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=hjb-sort.asp?page=" & intNum & ">" & intNum & "</a> "
Next
Response.Write "<p>"
If intPage > 1 Then
Response.Write "<a href=hjb-sort.asp?page=" & intPage - 1 & "><<</a>"
Else
Response.Write "<<"
End If
Response.Write " "
If intRecCount = 0 And intPage > 0 Then
Response.Write "<a href=hjb-sort.asp?page=" & intPage + 1 & ">>></a> "
Else
Response.Write ">>"
End If
%>
</body>
</html>
Er der nogen der kan se hvad der er galt ?
Johnny
