paging database results

They have: 5,633 posts

Joined: Jan 1970

Hi,

I'm ASP beginner and have problem with paging results from database recordset (access 2000).For easier understanding of my problem please check out the html version of the page:
http://www.dalmatianvilla.com/DalmatinskeVile/en/NEKRETNINE/realestate.htm
__________________________
There is a search form that searches my database. When I click "all" it shows all results from my recordset (I have only one rs)and the paging script shows: number of records,absolute page,number of pages,and "first-previous-next-last" links.It works fine except those links.

On the left side of the page you can see a white square which will show data (number of records,absolute page and number of pages).

So,the problem is showing when I start another search. For example:
houses>-50.000EUR>-50sq.m>dalmatia>SEARCH.

In that case data in the square remains the same as data for "all" results, and even if there are no results the page shows links "first-previous-next-last).
Also,every time when I click on that links I get error message.

I supose that I must change some parameters in the code that relate
to multiple form queries.
Thank you very much for your help and pardon my English!

They have: 3 posts

Joined: Oct 2003

There many ways of doing ASP paging. Please post your paging code here stripping out as much irrelevant code as possible so we can advice you on what to do next.

Mark Hensler's picture

He has: 4,048 posts

Joined: Aug 2000

Welcome to the TWF, dalmatian!

I haven't used ASP for about 3 years. Did a search, and this came up...
http://www.webmaster-forums.net/showthread.php?threadid=15355

Mark Hensler
If there is no answer on Google, then there is no question.

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.