20 records per page

Results 1 to 2 of 2

Thread: 20 records per page

  1. #1
    Join Date
    Dec 1969

    Default 20 records per page

    I've got a stored proc that's returning 1000+ records. I'd like to be able to return only 20 at a time. So the first page will display the 20 most recent records, then when a user hits "next 20" (or something similar), the next 20 records will be returned, etc... Not sure what the most efficient way to do this is? I'd appriciate any suggestions.

  2. #2
    Join Date
    Dec 1969

    Default FAQ'S

    I just saw a FAQ about stored procs and paging. THis is called recordset paging. Search for it in the FAQ&#039;s ....<BR><BR><BR>Hitman

Posting Permissions

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