Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ASP: show database results with X of Y count per page

Posted on 2004-10-26
4
Medium Priority
?
135 Views
Last Modified: 2010-08-05
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
Comment
Question by:billysaw
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 33

Accepted Solution

by:
sajuks earned 1500 total points
ID: 12409107
0
 
LVL 13

Expert Comment

by:nurbek
ID: 12409194
check this link also
easy and simple :)

http://www.asp101.com/samples/db_paging.asp
0
 

Author Comment

by:billysaw
ID: 12409796
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
 

Author Comment

by:billysaw
ID: 12456510
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I found this questions asking how to do this in many different forums, so I will describe here how to implement a solution using PHP and AJAX. The logical flow for the problem should be: Write an event handler for the first drop down box to get …
Without even knowing it, most of us are using web applications on a daily basis.  In fact, Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We generally confuse these web applications to…
Viewers will learn one way to get user input in Java. Introduce the Scanner object: Declare the variable that stores the user input: An example prompting the user for input: Methods you need to invoke in order to properly get  user input:
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

618 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question