paging database results
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!
Johan007 posted this at 14:58 — 7th October 2003.
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.
Johan De Silva Portfolio
Mark Hensler posted this at 03:29 — 8th October 2003.
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.