hur gör man för att behålla sina formulär värden när man kör ett paging scirpt?
Koden nedan funkar så länge som jag inte byter sida:
Set Rs7 = Connect.Execute("SELECT COUNT(id) AS Antal From members Where username Like '%%" & Replace(Request.Form("username"),"'","''") & "%%' AND kon Like '%%"& Request.Form("kon") &"%%'" & _
" AND (to_days(current_date) - to_days(foddes))/365.2405 between "& sqlAge &" AND stad Like '%%"& Request.Form("stad") &"%%' AND lan Like '%%"& Request.Form("lan") &"%%' AND status Like '%%"& Request.Form("online") &"%%'" & _
" And bild_godkand Like '%%"& Request.Form("bild") &"%%'")
pageSize = 15
page = request.querystring("page")
if page = "" then page = 1
End if
pages = (Rs7("Antal")-1)/pageSize + 1
SQL = "Select * From members Where username Like '%%" & Replace(Request.Form("username"),"'","''") & "%%' AND kon Like '%%"& Request.Form("kon") &"%%'" & _
" AND (to_days(current_date) - to_days(foddes))/365.2405 between "& sqlAge &" AND stad Like '%%"& Request.Form("stad") &"%%' AND lan Like '%%"& Request.Form("lan") &"%%' AND status Like '%%"& Request.Form("online") &"%%'" & _
" And bild_godkand Like '%%"& Request.Form("bild") &"%%' Order By "& ordning &" limit " & (page-1)*pagesize & "," & pageSize
Set RecSet = Connect.Execute(SQL)