billysaw
asked on
ASP: show database results with X of Y count per page
Hey,
I have been working on this ASP program. Now I have a long list of items that I want to present on a page like the search engines do- I am getting this stuff from an MS ACCESS database:
with a count of say 10 per page and then shows that cool thing at the bottom that says X of Y results with links to the next results ETC.
Does anyone have some concise code?
Billy
I have been working on this ASP program. Now I have a long list of items that I want to present on a page like the search engines do- I am getting this stuff from an MS ACCESS database:
with a count of say 10 per page and then shows that cool thing at the bottom that says X of Y results with links to the next results ETC.
Does anyone have some concise code?
Billy
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will get back to you. But all that code looks good. I need to see which one works the best before I implement.
billy
billy
ASKER
Still not getting a good job. The one from the four rolla guys worked ok. But the code stops working whenever I add the 'WHERE' statement. Is there something I am missing out. I am using PWS on WIN98 and all I did was replace the connection object and the SQL statements.
It works well with static, hard coded searches like
SELECT * FROM tbl_MYTABLE
and not with:
SELECT name,title,address FROM customers WHERE name="something here "
Am I missing something?
Billy.
It works well with static, hard coded searches like
SELECT * FROM tbl_MYTABLE
and not with:
SELECT name,title,address FROM customers WHERE name="something here "
Am I missing something?
Billy.
easy and simple :)
http://www.asp101.com/samples/db_paging.asp