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
