searching database on ASP

G

giharper

I added a search form to an Active Server Page that displays one record per
page, but if I run a search and page through several records, when I change
to other search terms, the first record does not come up, but it comes up on
the same record number in the second search. So instead of starting at
record/page 1 it will start at the record/page that I ended up on in the
first search (i.e. 20 of 711).
Any help would be appreciated.
 
S

Stefan B Rusynko

You obviously have an error in your paging script code (not checking for new record)
Take a look at http://www.asp101.com/samples/db_paged_search.asp




|I added a search form to an Active Server Page that displays one record per
| page, but if I run a search and page through several records, when I change
| to other search terms, the first record does not come up, but it comes up on
| the same record number in the second search. So instead of starting at
| record/page 1 it will start at the record/page that I ended up on in the
| first search (i.e. 20 of 711).
| Any help would be appreciated.
 
Top