Try to use Oracle Rownum property and you will get a good result. Say If your query returns 1000 records put another condition in your query as rownum<100 and then for next time put the condition as rownum>100 and rownum<200 you will get it solved. Thanx Yogaraj
-----Original Message----- From: JOSHY MON M C [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 14, 2002 2:04 PM To: [EMAIL PROTECTED] Subject: Urgent Help needed ! Hi All, Can Anybody help ? I have a Oracle 9i table named Contacts which contain about 10000 records. I need to show them in a JSP page ordered by last name or first name or in any other order (as per user request). But only 100 records should be shown at a time. User can click "Previous" or "Next" links to see more records ( as in Google/Yahoo search ) I have done this by creating a temporary table. Records are sorted and kept in the temporary table . But this seems to be a very slow and inefficient method. ( Each request involves a select from the original table, creation of tempory table, insertion into temp table and finally select from temp table. ) Can anybody suggest a better approach ? Thanks 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 "THIS E-MAIL MESSAGE ALONG WITH ANY ATTACHMENTS IS INTENDED ONLY FOR THE ADDRESSEE and may contain confidential and privileged information. If the reader of this message is not the intended recipient, you are notified that any dissemination, distribution or copy of this communication is strictly Prohibited. If you have received this message by error, please notify us immediately, return the original mail to the sender and delete the message from your system." =========================================================================== 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
