if you use Oracle you can use [top], that is Rownum if you use SqlServer you use limit
----- Original Message ----- From: srinivas tadikonda To: [EMAIL PROTECTED] Sent: Friday, September 06, 2002 1:25 PM Subject: Records Control Hi, How can I display limited records in one jsp page. My table haveing 50,000 records. I want to display these records into browser using jsp. If I try to display this much records my browser is hanging. because lot of records. so I want to display 1000 records each page. If user press next button , anothor 1000 records will come. at the same time user press previsous button also previous records will come. How can I control Resultset . Please tell me. If its possible please send code. Basically I want to Previous and Next buttons. If you have any better solution otherthan this please tell me. But My table haveing huge data. I want to display this into one report format. Regards srinivas ---------------------------------------------------------------------------- -- Send and receive Hotmail on your mobile device: Click Here =========================================================================== 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
