Really stuck

[Paul00000001]

Hey i am building a website with a database and i have a search form which queries the database and it works fine it displays the results 16 per page but my client wants to show 16 results per page then be able to click either first previous next and last and have the results refresh themselves on the same page as used on this website when you view the threads

Page 1 of 17 1 23411 > Last »
The code i have so far is below.


dim sale
dim sql
dim total
dim maxview

''below is just the sql query
sql = "SELECT * FROM Houses WHERE"
sql = sql & " Price >=" & request.form ("lower")
if request.form ("upper") <> "" then
sql = sql & " AND Price <=" & request.form ("upper")
end if
if request.form("Type") <> "any" then
sql = sql & " AND Type ='" & request.form ("Type") & "'"
end if
if request.form ("area") <> "any" then
sql = sql & " AND Area ='" & request.form ("area") & "'"
end if
if request.form ("bed") <> "0" then
sql = sql & " AND Bed >=" & request.form ("bed")
end if

if request.form ("View") = "Price" then
sql = sql & " ORDER BY Price desc"
end if
if request.form ("View") = "Date" then
sql = sql & " ORDER BY Updated desc"
end if
maxview = request.form("maxview")
´´Opening the database
Set sale = Server.CreateObject("ADODB.Recordset")
sale.Open sql, objConn
''Getting the total number of records that match
total = sale.recordcount



''Loop through 16 times to show the 16 results
dim maxview
maxview = 16
while (maxview <> 0) AND (NOT sale.EOF)

''Show the results

maxview = maxview - 1
sale.MoveNext()
wend


i know i have to use the .movefirst,.moveprevious,.movenext and .movelast but i am at a loss as how to use them. I have read tutorials on these methods but none of them relate to my problem.