• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 136
  • Last Modified:

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
0
billysaw
Asked:
billysaw
  • 2
1 Solution
 
nurbekCommented:
check this link also
easy and simple :)

http://www.asp101.com/samples/db_paging.asp
0
 
billysawAuthor Commented:
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
0
 
billysawAuthor Commented:
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.

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now