Re-using A Recordset 1

[OrWolf]

I've created a page that shows 10 records of a time of a recordset. I want to know if there is any way to use the existing RS as the user navigates the records, rather then running the SQL statement everytime the page is refreshed.

Make sense?

Thanks!

 

[durug]

You could use the hidden fields to store the recordset values, but it can increase the size of the page.
You could use client side cursor and then the network traffic will be not so big.

For an example check thread:
thread333-249800