Re: FN-FORUM Paging of Records

date posted 27th July 2000 15:01

Hi Steve,

Sorry, I haven't been following all the way so I don't know what language
you are using and stuff but:

Your form sends through varName to the script, it returns the results to the
browser.
Should it not also return a link that says:
Next
Previous

If the request("Page") variable doesn't exists assume it is one else use it
and increment it when you send the Next and Previous links out again.

Shawn
http://www.sbb.com


----- Original Message -----
From: "Stephen C Parker" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Thursday, July 27, 2000 2:50 PM
Subject: RE: FN-FORUM Paging of Records


> Perhaps I should provide an example of what I mean.
>
> Instead of: e.g. "Select * FROM whatevertable WHERE Name='Steve'" etc.
>
> I have got something like: "Select * FROM whatevertable WHERE Name='" &
> varName & "'"
>
> When the page goes to the second record, it loses the varName and as such
> the page fails.
>
> Suggestions will be warmly welcomed
>
> Sincerely,
> Steve
>
>
>
> Freelancers,
> Please help! I have seen many examples of paging recordests and they all
> work fine. They work fine because they have the SQL code all specifically
> set.
>
> e.g. "Select * FROM whatevertable WHERE Name='Steve'" etc.
>
> This will then be consistently used and retrieved for the many pages of
> results that there may be.
>
> What if your code has a variable value that has been Requested from a form
> from the previous page. This variable is then used within the SQL string
to
> retrieve the results. Then when the page tries to retrieve the second set
of
> results - it fails because it can no longer find the variable.
>
> I have since tried to get these variables to be re-sent for the second
> page - but it still does not work.
>
> Any ideas, clues, web references or offers to look at the code would be
much
> appreciated.
>
> Sincerely,
>
> Stephen C Parker
> [EMAIL REMOVED]
> http://www.orbinternet.com
> http://www.freelancers.net/scparker/index.html
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
> visit:
> http://www.freelancers.net/forum.html
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 1000 freelancers
>
> Freelancers and Freelance Jobs
> http://www.freelancers.net
>
> To post to the Forum:
> [EMAIL REMOVED]
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]
>
> To subscribe to the digest for this list or for further information please
visit:
> http://www.freelancers.net/forum.html