displaying records by 10

Results 1 to 3 of 3

Thread: displaying records by 10

  1. #1
    Join Date
    Dec 1969

    Default displaying records by 10

    If I have a Table with 100 records, how can I display them by 10 and go to the next 10 by a button or something?

  2. #2
    Join Date
    Dec 1969

    Default RE: displaying records by 10

    Hi,<BR> In the first page, create a recordset and use a do while loop and display the first 10 records. and now store the recordset in a session variable. In the page, assign the session variable to a recordset variable and use a similar do while loop to display the next 10 results. You can pass a querystring to the same page to know the last record displayed.<BR><BR>prasanna

  3. #3
    subzer0 Guest

    Default RE: displaying records by 10

    DO NOT STORE Recordsets to Session variables, it&#039ll bring your server to its knees.<BR><BR>Use bookmarks instead or re-run your queries for the next 10 records.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts