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

Posted on 2004-10-26
Last Modified: 2010-08-05

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?

Question by:billysaw
    LVL 33

    Accepted Solution

    LVL 13

    Expert Comment

    check this link also
    easy and simple :)

    Author Comment

    I will get back to you. But all that code looks good. I need to see which one works the best before I implement.


    Author Comment

    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


    and not with:

    SELECT name,title,address FROM customers WHERE name="something here "

    Am I missing something?



    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Suggested Solutions

    Title # Comments Views Activity
    How to make similar contact form? 8 45
    help with simple xml php 22 90
    video playback resume on webpages 2 45
    MVC and Angular 2 28
    Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL ( several years ago, it seemed like now was a good time to updat…
    Have you tried to learn about Unicode, UTF-8, and multibyte text encoding and all the articles are just too "academic" or too technical? This article aims to make the whole topic easy for just about anyone to understand.
    Viewers will learn about arithmetic and Boolean expressions in Java and the logical operators used to create Boolean expressions. We will cover the symbols used for arithmetic expressions and define each logical operator and how to use them in Boole…
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

    931 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

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now