I've found a few sites about paging recordsets in ASP as well as the thread on this board and I have used so many examples on how to page through records. I keep getting the same problem. I have a search and when the search returns the results on the 2nd page, you see the first 5 results of the query. Good. But when I click on the first/previous/next/last buttons, it navigates the 5 records through ALL the records and not just the results from the query. Any tips or suggestions where my error could be, would be very helpful. Thanks.
I have a search and results come up. Let's say there are 830 records in my database and my search brings up 40. So my results page displays the first 5 of the 40. When I click "next", it displays the second set of 5 out of my 830 records.
Check if you are passing the search criteria when you click "Next".
For example if your search begins at a form with a textbox called SearchBox and you are passing the criteria through a querystring your URL should have something like ?SearchBox=MySearchTerm at the end of it, make sure that when you click on "Next" you are passing the querystring in the URL for "Next".