ASP and Paging Recordsets

[bberrios]

I am having troubles getting my paging functionality to work completely. It appears to work, but when you click on any of the follwoing pages after 1, it re-quieries the entire database instead of carrying over the prior searches results....any suggestions as to why?

[Manish Malik]

Do you modify the query at each page, or do you try to use the same query for all pages and paginate yourself using code (deciding which results to display for the particular page)?

[bberrios]

I do not modify the query at each page, I am trying to use the same query. I am using the same query and paginating each page. Any suggestions...

[Manish Malik]

Originally posted by bberrios
I do not modify the query at each page, I am trying to use the same query. I am using the same query and paginating each page. Any suggestions...

One of the better ways to achieve this is to set the "PageSize" property of the RecordSet and then use the "AbsolutePage" property to move to a specific page. Look up msdn for these two properties of the recordset, that should do it.

[bberrios]

I have done this, that is why I am puzzled. I am attaching the page I am using (as a text file), maybe you can see something I don't. Thanks so much for all your input.

[bberrios]

does anyone have any suggestions..this is making me crazy. I even recoded it a different way and it still does the same thing. I can't figure out why?

Here is teh URL...but I don't know if it is accessable.

http://vhacoweb3/hcir/test_version13/ReportData.asp