Paging
Koden først:------------------------------------
<%
Const adOpenKeySet = 1
Const adLockReadOnly = 1
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Or intPage = "" Then
intPage = 1
End If
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<TITLE></TITLE>
</HEAD>
<BODY topmargin=4 leftmargin=0 marginwidth=0 marginheight=4 bgcolor="#524C4C" background="../pictures/bg/indhold.jpg" bgproperties="FIXED">
<table width="780" height="320" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="97" align="center" valign="middle">
<%
If intPage > 1 Then
back = intPage - 1
%>
<a href="oversigt.asp?page=<%=back%>" onMouseOver="imgOn('img2')" onMouseOut="imgOff('img2')">
<img src="../pictures/oversigt/forrige_boliger1.jpg" width=66 height=70 alt="Tilbage til side <%=back%>" border="0" name="img2"></a>
<% else %>
<% end if %>
</td>
<td width="5"> </td>
<td valign="top">
<div align="center"><img src="../pictures/oversigt/overskrift.jpg" width=315 height=40 alt="" border="0">
<table width="565" cellspacing="0" cellpadding="0" border="0">
<tr>
<td height="5" colspan="8"><img src="../pictures/standard/gennemsigtig.gif" width=1 height=1 alt="" border="0"></td>
</tr>
<tr>
<td valign="top"><b>Sag</b></td>
<td valign="top"><b>Beliggenhed</b></td>
<td align="center" valign="top"><b>Vær.</b></td>
<td align="right" valign="top"><b>Kvm.</b></td>
<td align="right" valign="top"><b>Kontant</b></td>
<td align="right" valign="top"><b>Udb.</b></td>
<td align="right" valign="top"><b>Brutto</b></td>
<td align="right" valign="top"><b>Netto</b></td>
</tr>
<tr>
<td height="5" colspan="8"><img src="../pictures/standard/gennemsigtig.gif" width=1 height=1 alt="" border="0"></td>
</tr>
<%
Set rs = Server.CreateObject("ADODB.RecordSet")
strSQL = "SELECT * FROM boliger ORDER BY oprettet DESC"
strDSN = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("/boliger/boliger.mdb")
' response.write "<p>" & strDSN & "<p>"
rs.Open strSQL, strDSN, adOpenKeySet, adLockReadOnly
If Not (rs.BOF Or rs.EOF) Then
rs.PageSize = 2
rs.AbsolutePage = intPage
intRecCount = rs.PageSize
intPageCount = rs.PageCount
Do While Not rs.EOF And intRecCount > 0
%>
<tr bgcolor="#524C4C">
<td valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("sag")%></a></td>
<td valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("adresse")%></a></td>
<td align="center" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("vaerelser")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("areal")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("kontant")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("udbetaling")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("brutto")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("netto")%></a></td>
</tr>
<%
intRecCount = intRecCount - 1
rs.MoveNext
%>
<% if rs.EOF Or intRecCount = 0 Then Exit Do %>
<tr>
<td valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("sag")%></a></td>
<td valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("adresse")%></a></td>
<td align="center" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("vaerelser")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("areal")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("kontant")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("udbetaling")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("brutto")%></a></td>
<td align="right" valign="top"><a href="bolig_info.asp?sag=<%=rs("sag")%>"><%=rs("netto")%></a></td>
</tr>
<%
intRecCount = intRecCount - 1
rs.MoveNext
Loop
End If
rs.Close
Set rs = Nothing
%>
</table>
<p>
<b>Side <%=intPage%> af <%=intPageCount%></b>
</div>
</td>
<td width="5"> </td>
<td width="97" align="center" valign="middle">
<%
If intRecCount = 0 And intPage > 0 Then
forward = intPage + 1
%>
<a href="oversigt.asp?page=<%=forward%>" onMouseOver="imgOn('img1')" onMouseOut="imgOff('img1')">
<img src="../pictures/oversigt/flere_boliger1.jpg" width=68 height=70 alt="Frem til side <%=forward%>" border="0" name="img1"></a>
<% else %>
<% end if %>
</td>
</tr>
</table>
</BODY>
</HTML>
-------------------------------------
Paging er en genial feature, MEN når jeg sætter antallet af records den skal vise til f.eks. 4 og der så kun er 4 records i databasen viser den "FLERE-BOLIGER"-knappen alligevel. Hvis jeg derimod sætter antallet af viste records til 3 og der er 4 i databasen viser den side 2 rigtig nok UDEN en "FLERE-BOLIGER"-knap !!!
Hvad gør jeg galt i min if-then-else sætning ???
HELP MEEEE
/David
