well... do one thing...
create one sequence field in ur table...
like start from 1.. 2.. 3 ......upto n...
create two variables that will hold the current sequence number and end sequence
number...
fine... first variable value is 1 and next variable value is 10..
write a query such that it will retrieve all row between that variables value...
now the first variable value is second variable.... fine
then increment the second variable by 10...
in the next button press...
the query retrieve next 10 records...
this is the simplest way....
another way also is there... by using collection variable...
if u not able to get the previous logic i will tell u the second method...
Q try for everything Q
regards
suriya
contech software ltd...
GIDC Estate
Ghandhinagar
ph:02712-43324(off)
:02712-35567(pp)
mail at:[EMAIL PROTECTED]
visit at:www.contechgroup.com
-----Original Message-----
From: N Hari Babu [SMTP:[EMAIL PROTECTED]]
Sent: Monday, August 07, 2000 10:16 AM
To: [EMAIL PROTECTED]
Subject: 10 Recs. per page
Deal all,
I have the following problem.
One query retrieves 100 records from the data base. These records to be
displayed in a JSP page 10 records at a time. How can i achieve this.
What would be the best way.
Thanks
Hari.
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
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".
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
