Alot people has asked this question over and over again.
And there are a few solutions for this.
If your data sets are small then it's better to store all returned records
in a bean and handle the prev and next with a index. (Save SQL query
overhead)
However if you anticipate using prev/next then your data sets must intend
to be really big. People have suggested storing unique key and query the
Database each time pre/next is requested.
It's a memory and performance trade-off. Does anyone have a good solution
for this?
> -----Original Message-----
> From: soumya Govardhana [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, February 20, 2001 2:25 PM
> To: [EMAIL PROTECTED]
> Subject: How to display x rows out of n with back/next buttons.
>
>
> Hi All,
> How to display x rows out of n rows retrieved from sql
> query to database with back/next buttons? I need this
> behavior for my diiferent pages/modules where I fire
> different query and may get different (no of) columns from
> data base. Some suggested CacheableRowsets and some suggested
> a hashtable/vector solutions. But I what a proper solution
> which is faster and applicable to all my modules. Example is
> better. I couldn't find similar ADO control for ASP. I tried
> in many sites, but vain.
> Help me out.
> Thanks.
> Soumya.
>
> ==============================================================
> =============
> 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
>
===========================================================================
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
