Paging....igen
Hvorfor får jeg en fejl på følgende script når jeg skifter side ??Jeg kan godt umiddelbart se at det er fordi min sql streng bliver tom, men hvad skal jeg gøre for at afhjælpe det.
Man kunne selvfølgelig gemmesqlen i en session, men det virker ikke som en holdbar løsning for mig...
<%
strKeyword = Request.form("keyword")
strOrderBy = request.form("orderby")
strSort = request.form("sort")
SQL = "Select * from links where "
SQL= SQL & "Beskrivelse like '%" & strKeyword &"%'"
SQL = SQL & " or Link like '%" & strKeyword &"%'"
SQL = SQL & " or author like '%" & strKeyword &"%'"
SQL = SQL & " order by " & strOrderby & " " & strSort
intPage = Request("page")
If isNumeric(intPage) = False Or intPage < 1 Then
intPage = 1
End If
if request.form("go") = "true" or request.querystring("page") <> "" then
Set rs = server.createObject("ADODB.Recordset")
DSN = "DRIVER={Microsoft Access Driver (*.mdb)}; "
DSN = dsn & "DBQ=" & server.mappath("db.mdb")
rs.open SQL, dsn, 1
if not rs.eof then
rs.PageSize = 7
rs.AbsolutePage = intPage
intRecCount = rs.PageSize
intPageCount = rs.PageCount
AntalP = rs.RecordCount
Response.write "Der er fundet " & AntalP & " poster.<br>"
Response.write "Side " & intpage & " af " & intPageCount & "<br>"
%></font><br>
<table width="95%" border="0" cellspacing="3" cellpadding="7">
<tr bgcolor="#660000" valign="top">
<td>
<div align="center"><font color="#FFCCCC" size="2" face="Verdana, Arial, Helvetica, sans-serif">
<%Do while not rs.eof and intRecCount > 0
response.write "<p><a href=" &rs("Link") & ">" &rs("Link") & "</a><br>" & rs("beskrivelse") & "</p>"
intRecCount = intRecCount - 1
rs.Movenext
loop
if request.querystring("page") = "" then
q = request.querystring & "&page="
elseif 0 < Cint(request.querystring("page"))<9 then
q = left(request.querystring, len(request.querystring)-1)
elseif cint(request.querystring("page")) > 9 then
q = left(request.querystring, len(request.querystring)-2)
end if
If Clng(intPage) > 1 Then
response.write "<a href=udskriv.asp?"& q & intpage-1& " class=skiftsidelinks>"
response.write "<<"
response.write "</a>"
response.write " - "
else
response.write "<Font color='#666666'><<</font> - "
end if
If Clng(intPage) < Clng(intPageCount) Then
response.write "<a href=udskriv.asp?" & q & intpage+1 & " class=skiftsidelinks>"
response.write ">>"
response.write "</a>"
else
response.write "<Font color='#666666'>>></font>"
end if
else
response.write "Der er ikke fundet noget"
end if
else
response.redirect("soeg.htm")
end if
%>
