intPage = Request(\"page\") If isNumeric(intPage) = False Or intPage < 1 Then intPage = 1 End If
Set rs = Server.CreateObject(\"ADODB.RecordSet\") strSQL = \"SELECT * FROM Billeder WHERE Arkivnummer=\" & Recid2 & \"\" strDSN = \"DRIVER={Microsoft Access Driver (*.mdb)};DBQ=\" & Server.MapPath(\"database.mdb\") rs.Open strSQL, strDSN, 1, 3 If Not (rs.BOF Or rs.EOF) Then rs.PageSize = 7 rs.AbsolutePage = intPage intRecCount = rs.PageSize intPageCount = rs.PageCount Response.Write \"<p><b>Side \" & intPage & \" af \" & intPageCount & \"</b></p>\" response.write \"<table border=\"\"0\"\" align=\"\"center\"\" width=\"\"380\"\">\" & vbcrlf count=0 Do While Not rs.EOF And intRecCount > 0 if (count mod 5)=0 then if count<>0 then response.write \"</tr>\" end if response.write \"<tr>\" end if Response.write \"<td><a href=\"\"images/arkivbilleder/\" & rs(\"Filnavn\") & \"\"\"><img src=images/arkivbilleder/thumbnails/\" & rs(\"Thumbnail\") & \" border=\"\"0\"\" height=\"\"50\"\" width=\"\"50\"\" alt=\"\"\" & rs(\"Billedbeskrivelse\") & \"\"\"></a><br><br><br></td>\" & vbcrlf count=count+1 intRecCount = intRecCount - 1 rs.MoveNext Loop response.write \"</tr></table>\" End If rs.Close Set rs = Nothing
Response.Write \"<p>Gå til side \" For intNum = 1 To intPageCount Response.Write \"<a href=paging.asp?page=\" & intNum & \">\" & intNum & \"</a> \" Next
Response.Write \"<p>\" If Clng(intPage) > 1 Then Response.Write \"<a href=paging.asp?page=\" & intPage - 1 & \"><<</a>\" Else Response.Write \"<<\" End If
Response.Write \" - \"
If Clng(intPage) < Clng(intPageCount) Then Response.Write \"<a href=paging.asp?page=\" & intPage + 1 & \">>></a> \" Else Response.Write \">>\" End If
%> </body></html>
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.