You should be able to store the query results in some
type of container within the HttpSession object (reference
setAttribute), and then retrieve and display the total
number of available logical pages to the user (number of
results / page size).
After the user selects which page to display (possibly
via text field or list selection), you can display the JSP
with the selected results in the HTML table.
Hope this helps. Rob
------Original Message------
From: Constantinos Giannacoulis <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Sent: February 7, 2001 3:28:44 AM GMT
Subject: JSP - SQL question
Hi all,
I have jsp page displaying a large number of rows (>200) returned from a
database search.
How can i split the resultset into logical pages and let the user choose
what page to display?
Thanks in advance,
Costas
===========================================================================
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
______________________________________________
FREE Personalized Email at Mail.com
Sign up at http://www.mail.com/?sr=signup
===========================================================================
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
