I think the best solution for this is James' pager
taglib from http://www.jsptags.com
Try it out, there is an example on his page.
That way it is more dynamic, and you dont have to
specify # to select in SQL stmt.
Hope that helps
--- EJB ForAll <[EMAIL PROTECTED]> wrote:
> hi dear,
>
>
> if You are using MySQL database then use the
> following
> query.
>
> select * from abc limit 0,20
>
> this will retrive only first 20 records.
>
> and in next page you can use the following query
>
> select * from abc limit 20,21
>
> Regards
> Deepak Kumar
> http://www.geocities.com/deepak_38
>
>
>
>
>
>
> --- ems vasudevan <[EMAIL PROTECTED]> wrote:
> > Hi All !
> > I want to select only a particula no of records
> > from the database to display like goolge is
> doing.I
> > don't want to select the entire set of resultset
> and
> > process in the clientside or storing in the
> > vector.If
> > a table contains large no of records, I want to
> > display it chunk by chunk.For that whenever i am
> > contacting the database i want to select a set of
> > records.Any ideas?
> >
> > __________________________________________________
> > Do You Yahoo!?
> > Spot the hottest trends in music, movies, and
> more.
> > http://buzz.yahoo.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
>
>
> __________________________________________________
> Do You Yahoo!?
> Spot the hottest trends in music, movies, and more.
> http://buzz.yahoo.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
__________________________________________________
Do You Yahoo!?
Spot the hottest trends in music, movies, and more.
http://buzz.yahoo.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
