Peter, You might really want to reconsider storing your result set in the session. This approach will not scale very well and is apt to cause your application server to run out of memory. If the number of users gets large, you will be consuming a large amount of memory just to store the result sets in memory. A better approach is to query for the # of rows in the result set and then make a query for only the subset of rows that you want to display. This topic has been covered on this list many times. Do a search on paging result sets. There are tag libs available that will do it for you.
Regards, Richard > -----Original Message----- > From: Murali Mohan [SMTP:[EMAIL PROTECTED] > Sent: Thursday, April 03, 2003 4:32 AM > To: [EMAIL PROTECTED] > Subject: Re: 10 By 10 > > we assume s we have 100 vectors v1,v2,v3.....v100 and has some data. > > My main vector is Vector v= new Vector(); > v.addElement(v1); > v.addElement(v2); > ..... > ....... > v.addElement(v100); > > Now Declare a variable position to keep track of displaying data. First > position > value should be 0 . > Use this postion value to diaplay data in main vector. First u diaplay > v[0] data > and then increment postion to 1 and diaply v[1] data and soon. > In this way u can display first 10 vectors data as u want and > increment > position to 10. > When we click on next button use the current position value 10 and display > from 10 > to 20 and increment position value to 20 to display remaining data. > > I hope this helps u. > > regards, > Murali > > Venkat wrote: > > > Hi, > > Then How did you get the next 10 vectors and by clicking next? > > > > regards > > venkat > > > > -----Original Message----- > > From: A mailing list about Java Server Pages specification and reference > > [mailto:[EMAIL PROTECTED] Behalf Of Murali Mohan > > Sent: Thursday, April 03, 2003 5:19 PM > > To: [EMAIL PROTECTED] > > Subject: Re: 10 By 10 > > > > Hi A Vector contains all the vectors as elements which contains DB > data. > > I never store either the main vector or the inside vectors in session. > > > > regards, > > Murali > > > > Venkat wrote: > > > > > Hi Murali, > > > Where do you store these vectors? > > > In a session? > > > > > > regards > > > venkat > > > > > > -----Original Message----- > > > From: A mailing list about Java Server Pages specification and > reference > > > [mailto:[EMAIL PROTECTED] Behalf Of Murali Mohan > > > Sent: Thursday, April 03, 2003 4:24 PM > > > To: [EMAIL PROTECTED] > > > Subject: Re: 10 By 10 > > > > > > Hi Peter, > > > Yes I have done it by using only JSP. > > > > > > I got the records in a Vector of Vectors. The inside vectors contains > DB > > > data. First we show first vector data and if we click on next button > we > > show > > > next vector data and soon.... > > > > > > I hope u got it. > > > > > > regards, > > > Murali` > > > > > > Peter wrote: > > > > > > > hi all > > > > at out set i thank all the person's who answered my question on > screen > > > format > > > > now i am again back > > > > > > > > assume a resultant after executing a query has 1000 rows i don't > want to > > > show that immediately i want to show 10 by 10 using a button next but > the > > > fact is i dont want to disturb the database again it must be done with > the > > > help of some jsp technique.. > > > > > > > > Regards > > > > Peter > > > > > > > > > > > > > > ========================================================================== > = > > > > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > > > JSP-INTEREST". > > > > For digest: mailto [EMAIL PROTECTED] with body: "set > JSP-INTEREST > > > DIGEST". > > > > > > > > Some relevant archives, FAQs and Forums on JSPs can be found at: > > > > > > > > http://java.sun.com/products/jsp > > > > http://archives.java.sun.com/jsp-interest.html > > > > http://forums.java.sun.com > > > > 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 archives, FAQs and Forums on JSPs can be found at: > > > > > > http://java.sun.com/products/jsp > > > http://archives.java.sun.com/jsp-interest.html > > > http://forums.java.sun.com > > > 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 archives, FAQs and Forums on JSPs can be found at: > > > > > > http://java.sun.com/products/jsp > > > http://archives.java.sun.com/jsp-interest.html > > > http://forums.java.sun.com > > > 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 archives, FAQs and Forums on JSPs can be found at: > > > > http://java.sun.com/products/jsp > > http://archives.java.sun.com/jsp-interest.html > > http://forums.java.sun.com > > 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 archives, FAQs and Forums on JSPs can be found at: > > > > http://java.sun.com/products/jsp > > http://archives.java.sun.com/jsp-interest.html > > http://forums.java.sun.com > > 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 archives, FAQs and Forums on JSPs can be found at: > > http://java.sun.com/products/jsp > http://archives.java.sun.com/jsp-interest.html > http://forums.java.sun.com > 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 archives, FAQs and Forums on JSPs can be found at: http://java.sun.com/products/jsp http://archives.java.sun.com/jsp-interest.html http://forums.java.sun.com http://www.jspinsider.com
