Does anyone happen to know how to do this same query in SQL. I am using Microsoft SQL 2000 and can't find a similar query to accomplish this same task. Any help would be appreciated.
Eric ----- Original Message ----- From: "Peter Dolukhanov" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 03, 2002 02:33 pm Subject: Re: List page problem - JSP > 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 > =========================================================================== 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
