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

Thread: Paging thru recordsets via web

  1. #1
    Join Date
    Feb 2001
    Posts
    1

    Post

    Greetings,

    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 mopacfan@yahoo.com.

    Thank you,

    Michael Netherton

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    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:

    [url]http://www.dbasupport.com/forums/showthread.php?threadid=5480[/url]

    Hope this helps,

    - Chris

  3. #3
    Join Date
    Feb 2001
    Posts
    66
    You use ADODB?
    the cursor may be on the client side
    rs.cursorlocation=aduseclient
    rs.cachesize=100
    rs.CursorType = adOpenStatic
    rs.LockType = adLockReadOnly
    rs.open 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
    [url]http://www.learnasp.com/learn/dbtablepaged.asp[/url]

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