searching database on ASP

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top