Hvad er der galt ?
Jeg prøvede at sætte Paging af et recordset ind i dette script, MEN..En anden ting er hvordan laver man sådanne at ./images/egenside1.gif kun bliver vist hvis der er et link at vise ??
<% ShowHeader("List by Category") %>
<%
Session.LCID = 1030
Dim Connect, Klasse, Query, Category
Category = Trim(Request("Category"))
If Category = "" Then
Response.Write "No Category specified.<p>"
Else
Set Connect = Server.CreateObject("ADODB.Connection")
Connect.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("testbase") & ";DefaultDir=\;DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5"
Query = "SELECT ItemNum,Item,Description,Price,State,Email,Url FROM Items "
Query = Query & "WHERE Category='" & Category & "'"
Set Klasse = Connect.Execute(Query)
'Number of Items per page
NumPages =10
%>
<p align="left"><font size="4"><b><%=Category%>
</font>
<table border="0" width="600" cellspacing="0" cellpadding="0">
<tr>
<td width="445" valign="top"><div align="center"><center>
<table border="1" bgcolor="#FFFFFF" width="444" bordercolor="#FFFFFF" cellspacing="0"
cellpadding="5">
<tr>
<th align="left" width="403" bgcolor="#000080" style="background-color: #000080"><small><font color="#FFFFFF" face="Tahoma">Emne</font></small></th>
<th align="center" width="27" bgcolor="#000080" style="background-color: #000080" valign="middle"><small><font color="#FFFFFF" face="Tahoma">Pris</font></small></th>
<th align="center" width="30" bgcolor="#000080" style="background-color: #000080" valign="middle"><small><font color="#FFFFFF" face="Tahoma">By</font></small></th>
</tr>
<%
Do While Not Klasse.EOF %>
<%
' Something found
TotalRows = klasse.RecordCount
klasse.PageSize = NumPages
TotalPages=klasse.PageCount
select case Request.QueryString("move")
case "first" pageNo = 1 ' First
case "previous" pageNo = cint(Session("page_num")) - 1 ' Next
case "next" pageNo = cint(Session("page_num")) + 1 ' Previous
case "last" pageNo = TotalPages ' Last
case Else PageNo = 1
End Select
if cint(PageNo) < 1 then PageNo = 1
if cint(PageNo) > TotalPages then pageNo = TotalPages
klasse.AbsolutePage = PageNo
PageNumber=PageNo
Session("page_num") = PageNo
HowMany = 0
Response.Write "<div align='left'><table border='0' width='400'>"
Do until klasse.EOF or HowMany => NumPages
%>
<tr>
<td bgcolor="#EFEFEF" align="left" valign="middle" height="40"><small><a href="detail.asp?item=<%=Klasse("ItemNum")%>"><%=Klasse("Item")%></a></small><br><font face="Arial" size="2"><%=Klasse("Description") & " "%><%=Klasse("State")& " - "%></font></td>
<td bgcolor="#EFEFEF" align="center" valign="middle" height="40"><small><a href="mailto:<%=Klasse("Email")%>"
target="_blank"><img border="0" src="./images/email.gif" alt="Email" width="14" height="11"></a></p>
<td bgcolor="#EFEFEF" align="center" valign="middle" height="40"><small><a href="http://<%=Klasse("Url")%>"
target="_blank"><img border="0" src="./images/egenside1.gif" alt="Internetside" width="18" height="22"></a></p>
</td>
</tr>
<%
Klasse.MoveNext
howmany = howmany + 1
Loop
%>
<%Response.Write "</table>"%>
<%' set klasse = klasse.NextRecordset %>
<%Response.Write "<a href='foreningssider.asp?mode=show&move=previous'"%>target="_self"><img border="0" src="./images/forrigeside.gif" alt="Internetside" width="81" height="29"></a></p>
<%Response.Write "<a href='foreningssider.asp?mode=show&move=next'"%>target="_self"><img border="0" src="./images/naesteside.gif" alt="Internetside" width="81" height="29"></a></p>
<%
Connect.close
set Connect = nothing
%>
<tr>
<td><p align="right"><font face="Veranda, Arial" size="2" ><%= PageNumber %>
af <%= TotalPages %> sider</p>
<p align="left"><font color="#000080"><%
End sub
End If
%>
/mille
