Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » JSP Interest »

MS SQL Server and Paged Record Sets

Peter Dolukhanov

2003-07-17


Dear All,



I am having a problem whilst attempting to scroll through a record set
produced via a JDBC connection to a MS SQL: Server on a JSP page. The
two previous experiences I have had with this involved



a) using the LIMIT keyword on MySql

b) using cursors via ASP



There seems to be no coherent way to perform this using MS SQL Server, I
have found the TOP function, however not a way to specify to returns the
rows x -> y.



Does anyone have a solution for this as it must be possible. I even
recall a Tag Library that claims to achieve this.



Any ideas?



Many thanks in advance,



Peter Dolukhanov

===========================================================================
To unsubscribe: mailto listserv@(protected)".
For digest: mailto listserv@(protected)".

Some relevant archives, FAQs and Forums on JSPs can be found at:

http://java.sun.com/products/jsp
http://archives.java.sun.com/jsp-interest.html
http://forums.java.sun.com
http://www.jspinsider.com


©2008 junlu.com - Jax Systems, LLC, U.S.A.