RE: FN-FORUM Paging of Records

date posted 27th July 2000 14:45

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