Re: List page problem - JSP
Hi Eric, I had to use taglibs. Go to http://jsptags.com/tags/navigation/pager/ talk to you later, Will -Original Message- From: Eric Fleming [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 03, 2002 11:53 AM To: [EMAIL PROTECTED] Subject: Re: List page problem - JSP 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 === 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
Re: List page problem - JSP
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
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
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