Next, previous records from unique query pages

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fran7
    New Member
    • Jul 2006
    • 229

    Next, previous records from unique query pages

    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?firstn ame=bla&las tname=bla&p rofileid=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.

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

    Code:
    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
Working...