Easy (or better!) way of Paging?

Results 1 to 2 of 2

Thread: Easy (or better!) way of Paging?

  1. #1
    Join Date
    Dec 1969
    Posts
    1,912

    Default Easy (or better!) way of Paging?

    Hi!<BR><BR>I was wondering if anyone knew of a good way to page recordsets. At the moment, I am creating a recordset based on a form query. I&#039m setting a page size and using absolutepage to display the page. If the query creates a recordset of, say, 15 records and the page size is five, I submit all of the variables for the query to the asp page one more and the query is performed on the database again, this time choosing the next page number in the set.<BR><BR>I realize that this isn&#039t the best way of doing things. Can anyone suggest anything better?<BR><BR>Thanks!<BR>Dave

  2. #2
    manpreet Guest

    Default RE: Easy (or better!) way of Paging?

    i did this long back in java servlets. get the recordset first - the compete one. Put the resultset in the session. and well u have it. get going with the paging by first retreiving the rs from the session and then without executing the sql again, retreive the records from the recordset<BR><BR>i hope it helps!<BR><BR>

Posting Permissions

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