Recordset paging

[Phonez]

Does anyone know how to page through records properly.

I have got a messageboard on my site but when trying to view the next 5 records it does not seem to work.

The primary key is an autonumber which I am also having problems with because I keep getting a type mismatch error when I try to compare it with a variable.

Any help would be gratefull.

 

[Ovatvvon]

Check out this FAQ on recordset paging: faq333-186

With comparing variables, make sure you force their types to the same to make sure you are making a valid comparison...you can't compare a string and an integer, so if it's a number like the autonumber PK field, compare like so...

If rs("autoNumberPK&quot = CInt(myVariable) Then
Response.write "They are the same"
Else
Response.write "Not the same"
End If

Hope this helps. -Ovatvvon :-Q