exempel:
<!-- #include file="adovbs.inc" -->
<% intPage = Request("page")
<!-- her kan du deklarera dina variabler-->
navn = Request("navn")
email = Request("email")
<!-- decklarera slut -->
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
<!-- HeR SKRIVER DU DIN SQL SATS db kopling -->
set objConn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "Select * From TABEL navn, epost, bla... ORDER BY DATE DESC"
strDSN = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath("access.mdb")
objConn.open strDSN
rs.Open strSQL, objConn, 3, 3
If Rs.EOF Then
Response.Write"SORRY... BUT NOTHING IN THIS GESTBOOK"
Response.Write"<br><center>"
Response.Write "<a href='JavaScript:history.back(1)'>back</a></center>"
Else
%>
<table style="TABLE-LAYOUT: fixed" align="center" cellspacing="2" cellpadding="0" border="0" WIDTH="600" bgcolor="#ff8C00">
<tr><td align="center"><h1><a href="menu.asp">xxxxx</a></h1></td>
<td align="center"><h1><a href="menu1.asp">xxxxxxx</a></h1></td>
<td align="center"><h1><a href="menu2.asp">xxxxxxxxxx</a></h1></td>
<td align="center"><h1><a href="menu3.asp">xxxxxxxxxxx</a></h1></td>
<td align="center"><h1><a href="menu4.asp">xxxxxxxxxxxxxxx</a></h1></td>
<%
If Not (rs.BOF Or rs.EOF) Then
rs.PageSize = 10 '<<<<<<---- her kan du velja hurmånga sida du vill visa på engang ex: 10 eller 20 ...
rs.AbsolutePage = intPage
intRecCount = rs.PageSize
intPageCount = rs.PageCount
Response.Write "<p><b>Sida " & intPage & " av " & intPageCount & "</b></p>"
Do While Not rs.EOF And intRecCount > 0 %>
<!-- HeR SKRIVER DU UT TABEL SOM DU HEMTAR MED SQL SATSEN -->
<table style="TABLE-LAYOUT: fixed" align="center" cellspacing="0" cellpadding="0" border="0" WIDTH="600">
<tr><td align=left WIDTH = 90><h5><%= FormatDateTime(Rs("datum"),2)%></h5></td>
<td align=left WIDTH = 120><h5> <% =TRIM(Server.HTMLEncode(Rs("email")))%></h5></td>
<td align=left WIDTH = 120><h5> <% =TRIM(Server.HTMLEncode(Rs("navn")))%></h5></td></tr></table>
<!-- Tabell slut --> </tr></table>
<% intRecCount = intRecCount - 1
rs.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
Response.Write "<p>Gå til sida "
For intNum = 1 To intPageCount
Response.Write "<a href=""dinsidanavn.asp?page=" & intNum & "&navn=" & Server.URLEncode(navn) & "&epost=" & Server.URLEncode(epost) & """>" & intNum & "</a> "
Next
End if
%>