Generally you can use a scrollable cursor for this or
you fetch it all and cache it.
> -----Original Message-----
> From: A mailing list for discussion about Sun Microsystem's Java Servlet
> API Technology. [mailto:[EMAIL PROTECTED]]On Behalf Of
> Sudarson_Pratihar
> Sent: Sunday, May 06, 2001 7:46 AM
> To: [EMAIL PROTECTED]
> Subject: Shwing Paged Result in Servlet Page
>
>
> Hi All,
>
> This is a very common situation. Suppose we have a servlet that shows us a
> report/summary depending on some condition and we want to show only 25
> result per page. Then user have to navigate thru the pages thru 1,2,3 type
> of navigation of link. Now my question is :
>
> Is it possible to excute the query once only, because firing
> query ecah time
> may not be feasible, and so only 25 data and when he navigates to
> page to 2,
> page no. 2 contents?
>
> Thanks and Regards,
> Sudarson
>
> __________________________________________________________________
> _________
> To unsubscribe, send email to [EMAIL PROTECTED] and include
> in the body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
>
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
