Next, previous records from unique query pages

[fran7]

Hi, I wonder if anyone could point mne in the right direction. I have many many individual members profile pages. Each has a unique query.

http://www.site/page.asp?firstname=bla&lastname=bla&profil eid=2933

I want to have a link on each profile page to the next profile page with a previous link too.

Every sample of pagination that I have found are where there are multiple results returned and therefore are split into pages in groups.

What I need and cannot seem to find is a way to move from one unique id page to another.

The pages in question have a request query at the top.

lngprofileid=CLng(Request("profileid"))
If lngprofileid <> "" And lngprofileid <> 0 Then
 
    Set rs=Server.CreateObject("ADODB.Recordset")
    rs.CursorLocation = 3

and ending with

SQLQuery= SQLQuery & "  P.profileid=" & Clng(lngprofileid) & " "

Obviously I am not looping through multiple records so I cannot see how I would go to the next profileid

Thanks for any pointers
Much appreciated.
Richard