---
title: "Klurig sidor SQL.."
type: "forum-thread"
url: "https://www.webforum.nu/amne/asp/96726-klurig-sidor-sql"
topic: "ASP"
topic_url: "https://www.webforum.nu/amne/asp"
author: "Bosse168"
published: "2004-02-06T16:42:43.000Z"
updated: "2004-02-06T16:49:42.000Z"
replies: 1
views: 227
page: 1
pages: 1
language: "sv-SE"
site: "webForum — webforum.nu"
rights: "Upphovsrätten till varje inlägg tillhör dess författare."
attribution: "Citera som: webForum, https://www.webforum.nu/amne/asp/96726-klurig-sidor-sql"
---

# Klurig sidor SQL..

## #1 — Bosse168, 2004-02-06T16:42Z

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)
```

Permalänk: https://www.webforum.nu/p/96726

## #2 — LarsG, 2004-02-06T16:49Z

Du får väl lagra pagesize et.c. i session eller liknande (skicka som hidden fields eller i querystring.

Flyttas från SQL

Permalänk: https://www.webforum.nu/p/1270256

---

Tråden på webben: https://www.webforum.nu/amne/asp/96726-klurig-sidor-sql