Try using the command: SELECT * FROM TABLE LIMIT 0,50;
Obviously changing the numbers does what you need. Cheers, Pete -----Original Message----- From: A mailing list about Java Server Pages specification and reference [mailto:[EMAIL PROTECTED]] On Behalf Of JOSHY MON M C Sent: 03 April 2002 19:42 To: [EMAIL PROTECTED] Subject: List page problem - JSP Hi All I have a JSP page that displays a list. The list is shown querying against a database( oracle). It displays data when there few items in the list. If there are 1000 items or so, the list is not displaying, the page hangs. why ? What to do if I need to display the list batchwise (pagewise) say 50 items /page ? How to do that in Db? can anyone help ? Thanks in advance joshy ======================================================================== === 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com