Paging thru recordsets via web

[mopacfan]

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

[chrisrlong]

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

[m_d_marian]

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]