The problem with using ROWS is that 1) not all databases support it, and 2)
the underlying data could change, so that when you scrolled back, new
records were inserted into the stream.
>From: Peter Pilgrim <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and
> reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: Re: Iterator of range or rows ?
>Date: Thu, 15 Feb 2001 10:10:03 +0000
>
>Why dont you use the scrollable result set in JDBC 2.0
>
>Or if your database why now use the "ROWS" pseudo column
>
>select * from EMPLOYEE_RECORD where ROWS > 10 and ROWS < 20
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
