Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

SELECT ... NEXT ??

Discussion in 'Information Technology' started by PW, Jul 28, 2006.

Tags:
  1. PW

    PW
    Expand Collapse
    Guest

    I am writing an ASP application which sits on top of an Access database
    which contains a table with over 100K records.

    I need to display approx 10 records at a time. Therefore I dont want to
    "select * from table" and then page, as the initial "select" statement will
    be very slow to perform.

    Is there such a thing as "SELECT NEXT 10 * FROM TABLE" or something similar,
    where I can just retrieve the initial 10 records, and subsequently fetch the
    next 10 when the user clicks a "next" button?
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Try this link link

    http://rosca.net/writing/articles/serverside_paging.asp

    Good luck


    --
    Wayne




    "PW" wrote:

    >
    >
    > I am writing an ASP application which sits on top of an Access database
    > which contains a table with over 100K records.
    >
    > I need to display approx 10 records at a time. Therefore I dont want to
    > "select * from table" and then page, as the initial "select" statement will
    > be very slow to perform.
    >
    > Is there such a thing as "SELECT NEXT 10 * FROM TABLE" or something similar,
    > where I can just retrieve the initial 10 records, and subsequently fetch the
    > next 10 when the user clicks a "next" button?
    >
    >
    >
    >
    >
     

Share This Page