Paging of Records

date posted 27th July 2000 14:24

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