Paging thru recordsets via web Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Paging thru recordsets via web

  1. #1
    Join Date
    Feb 2001



    I am an asp developer and have just been given an assignment to create an adminstration interface for an extremely large oracle database. The ASP code I normally use to page through a MS/SQL or Access recordset does not seem to work properly when accessing an oracle table. I would be very grateful if someone could give me an example of ASP code that would allow me to set the number of records per page and move forward or backward through the recordset. Please send anything you think will help to

    Thank you,

    Michael Netherton

  2. #2
    Join Date
    Nov 2000
    Baltimore, MD USA
    Well, I don't have anything on the ASP side to give you, but here is a link to a discussion about implementing the scrolling window from the database side:


    Hope this helps,

    - Chris

  3. #3
    Join Date
    Feb 2001
    You use ADODB?
    the cursor may be on the client side
    rs.CursorType = adOpenStatic
    rs.LockType = adLockReadOnly mySQL,connectme
    rs.pagesize= nb of rows wanted
    (number of pages)=cint(rstemp.pagecount)
    rs.absolutepage= (position of the page)

    You better check this to have the complet example

Posting Permissions

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

Click Here to Expand Forum to Full Width