RE: Paging for table...
Hi, I always wondered a question about this kind of server side paging: THE PROBLEM: I suppose it is based on getting all the results at once from the database and storing them in session. Further on, data is extracted in slots from the session and thrown to a JSP for rendering. Well, I guess that, if this session data is large, in clustered environments, the data is balanced among the different servers causing a high network traffic which becomes in a performance issue for the whole system. Even worst, a lot of times just a small amount of data is browsed from the client side, so there is not reason to catch MBs in session. Is it not a bad design pattern? THE GUESSED SOLUTION: Would not it be better to make a new query to the datasource (database usually), in order to recover just a slot of data, store it in request scope and send to the JSP for rendering. Would not be this second approach save machine resources? In that way server would not be context aware, and would work just as proxy/formatter among client and datasource. Is not better approach? Or perhaps would depends on the data size to be fetched? Thanks for your opinions, Adolfo. From: [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Paging for table... Date: Sun, 4 Jan 2004 10:50:22 +0530 David, Check for the details on http://www.servletsuite.com/servlets/pagertag.htm Rahul -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 10:48 AM To: Struts Users Mailing List Subject: RE: Paging for table... Rahul, What is this paging taglib? Do you have a url? Curious, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 12:15 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Paging for table... Check for paging taglib available for struts which will meet your requirements. Rahul -Original Message- From: Vasudevrao Gupta M V S S S (WT01 - UTILITIES) Sent: Saturday, January 03, 2004 8:57 PM To: 'David Friedman'; 'Struts Users Mailing List' Subject: RE: Paging for table... .Can you please send across the sample code that you have developed??? -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004 20:57 To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: Paging for table... I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended
Re: Paging for table...
If you are talking about an SQL database, this is exactly the concept of cursor scrolling. The JDBC standard calls the same thing result set scrolling. The problem is that not all databases provide good support for this. In particular, the most popular database among corporations, Oracle, does not support cursor scrolling at the database engine level. Oracle does support result set scrolling, but accomplishes it by buffering the query result in the JDBC driver memory space on the client or application server. The real difficulty with this concept for databases is the necessity to support SQL operators like ORDER BY, GROUP BY, SELECT DISTINCT, COUNT(DISTINCT, UNION, MINUS, DIFFER, etc. which often involve sorting. The final order of the rows is not known until the sort steps are completed. Ed - Original Message - From: Adolfo Miguelez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 04, 2004 10:41 AM Subject: RE: Paging for table... Hi, I always wondered a question about this kind of server side paging: THE PROBLEM: I suppose it is based on getting all the results at once from the database and storing them in session. Further on, data is extracted in slots from the session and thrown to a JSP for rendering. Well, I guess that, if this session data is large, in clustered environments, the data is balanced among the different servers causing a high network traffic which becomes in a performance issue for the whole system. Even worst, a lot of times just a small amount of data is browsed from the client side, so there is not reason to catch MBs in session. Is it not a bad design pattern? THE GUESSED SOLUTION: Would not it be better to make a new query to the datasource (database usually), in order to recover just a slot of data, store it in request scope and send to the JSP for rendering. Would not be this second approach save machine resources? In that way server would not be context aware, and would work just as proxy/formatter among client and datasource. Is not better approach? Or perhaps would depends on the data size to be fetched? Thanks for your opinions, Adolfo. From: [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Paging for table... Date: Sun, 4 Jan 2004 10:50:22 +0530 David, Check for the details on http://www.servletsuite.com/servlets/pagertag.htm Rahul -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 10:48 AM To: Struts Users Mailing List Subject: RE: Paging for table... Rahul, What is this paging taglib? Do you have a url? Curious, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 12:15 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Paging for table... Check for paging taglib available for struts which will meet your requirements. Rahul -Original Message- From: Vasudevrao Gupta M V S S S (WT01 - UTILITIES) Sent: Saturday, January 03, 2004 8:57 PM To: 'David Friedman'; 'Struts Users Mailing List' Subject: RE: Paging for table... .Can you please send across the sample code that you have developed??? -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004 20:57 To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: Paging for table... I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender
Re: Paging for table...
Ed, any URL(s) which might enlighten me further on resultset/cursor scrolling and the support provided by different databses in this regard. Thanks, Santosh Ed Dowgiallo wrote: If you are talking about an SQL database, this is exactly the concept of cursor scrolling. The JDBC standard calls the same thing result set scrolling. The problem is that not all databases provide good support for this. In particular, the most popular database among corporations, Oracle, does not support cursor scrolling at the database engine level. Oracle does support result set scrolling, but accomplishes it by buffering the query result in the JDBC driver memory space on the client or application server. The real difficulty with this concept for databases is the necessity to support SQL operators like ORDER BY, GROUP BY, SELECT DISTINCT, COUNT(DISTINCT, UNION, MINUS, DIFFER, etc. which often involve sorting. The final order of the rows is not known until the sort steps are completed. Ed - Original Message - From: Adolfo Miguelez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, January 04, 2004 10:41 AM Subject: RE: Paging for table... Hi, I always wondered a question about this kind of server side paging: THE PROBLEM: I suppose it is based on getting all the results at once from the database and storing them in session. Further on, data is extracted in slots from the session and thrown to a JSP for rendering. Well, I guess that, if this session data is large, in clustered environments, the data is balanced among the different servers causing a high network traffic which becomes in a performance issue for the whole system. Even worst, a lot of times just a small amount of data is browsed from the client side, so there is not reason to catch MBs in session. Is it not a bad design pattern? THE GUESSED SOLUTION: Would not it be better to make a new query to the datasource (database usually), in order to recover just a slot of data, store it in request scope and send to the JSP for rendering. Would not be this second approach save machine resources? In that way server would not be context aware, and would work just as proxy/formatter among client and datasource. Is not better approach? Or perhaps would depends on the data size to be fetched? Thanks for your opinions, Adolfo. From: [EMAIL PROTECTED] Reply-To: Struts Users Mailing List [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: Paging for table... Date: Sun, 4 Jan 2004 10:50:22 +0530 David, Check for the details on http://www.servletsuite.com/servlets/pagertag.htm Rahul -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 10:48 AM To: Struts Users Mailing List Subject: RE: Paging for table... Rahul, What is this paging taglib? Do you have a url? Curious, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 12:15 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Paging for table... Check for paging taglib available for struts which will meet your requirements. Rahul -Original Message- From: Vasudevrao Gupta M V S S S (WT01 - UTILITIES) Sent: Saturday, January 03, 2004 8:57 PM To: 'David Friedman'; 'Struts Users Mailing List' Subject: RE: Paging for table... .Can you please send across the sample code that you have developed??? -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004 20:57 To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: Paging for table... I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain
RE: Paging for table...
I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Paging for table...
.Can you please send across the sample code that you have developed??? -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004 20:57 To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: Paging for table... I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Paging for table...
The site I gave you, www.displaytag.org (with source and binaries available from SourceForge.net), lists plenty of examples and code. Basically, you have a collection of objects (usually in request or session scope, but you can do it in page scope) and set your tag with the columns. From their basic columns example, if you have a List stored as test, for each item you can display the fields id, name, email, status, description using the below code: display:table name=test display:column property=id / display:column property=name / display:column property=email / display:column property=status / display:column property=description / /display:table Just keep in mind the binary updates a few jars to newer versions. Off the top of my head, I think it updates (don't pay attention, I just code *grin*) commons-lang, commons-beanutils, commons-logging, and commons-collections. But don't worry, they are in the binary distribution's example .war application and work fine with Struts v1.1 (probably with v1.0 as well). Also, fancier things are available, such as sorting, grouping, and downloading the fields as excel, csv, and xml. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 10:27 AM To: 'David Friedman'; 'Struts Users Mailing List' Subject: RE: Paging for table... .Can you please send across the sample code that you have developed??? -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004 20:57 To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: Paging for table... I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Paging for table...
Check for paging taglib available for struts which will meet your requirements. Rahul -Original Message- From: Vasudevrao Gupta M V S S S (WT01 - UTILITIES) Sent: Saturday, January 03, 2004 8:57 PM To: 'David Friedman'; 'Struts Users Mailing List' Subject: RE: Paging for table... .Can you please send across the sample code that you have developed??? -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004 20:57 To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: Paging for table... I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Paging for table...
Rahul, What is this paging taglib? Do you have a url? Curious, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 12:15 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Paging for table... Check for paging taglib available for struts which will meet your requirements. Rahul -Original Message- From: Vasudevrao Gupta M V S S S (WT01 - UTILITIES) Sent: Saturday, January 03, 2004 8:57 PM To: 'David Friedman'; 'Struts Users Mailing List' Subject: RE: Paging for table... .Can you please send across the sample code that you have developed??? -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004 20:57 To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: Paging for table... I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Paging for table...
David, Check for the details on http://www.servletsuite.com/servlets/pagertag.htm Rahul -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 10:48 AM To: Struts Users Mailing List Subject: RE: Paging for table... Rahul, What is this paging taglib? Do you have a url? Curious, David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, January 04, 2004 12:15 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: Paging for table... Check for paging taglib available for struts which will meet your requirements. Rahul -Original Message- From: Vasudevrao Gupta M V S S S (WT01 - UTILITIES) Sent: Saturday, January 03, 2004 8:57 PM To: 'David Friedman'; 'Struts Users Mailing List' Subject: RE: Paging for table... .Can you please send across the sample code that you have developed??? -Original Message- From: David Friedman [mailto:[EMAIL PROTECTED] Sent: 03 January 2004 20:57 To: Struts Users Mailing List; [EMAIL PROTECTED] Subject: RE: Paging for table... I use displaytag, www.displaytag.org, for that. Regards, David -Original Message- From: vasudevrao gupta [mailto:[EMAIL PROTECTED] Sent: Saturday, January 03, 2004 7:40 AM To: 'Struts Users Mailing List' Subject: Paging for table... Hi, I have a requirement where in user executes a query and gets some x number of records. I have to show the user 1-y records per page and when user clicks next button, he should be be able to see next y number of records.(Similar to yahoo site ). Can any one pls tell me if struts frame work provides any inbuilt framework to do this kind of paging Regards VasudevRaoGupta Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Confidentiality Notice The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain confidential or privileged information. If you are not the intended recipient, please notify the sender at Wipro or [EMAIL PROTECTED] immediately and destroy all copies of this message and any attachments. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
Mauricio, You can look at 'struts-layout' : http://struts.application-servers.com/ It is a quite powerful taglib that includes, among other stuff, paging management. Fred Le lun 03/11/2003 12:43, Mauricio T. Ferraz a crit : Hi People!!! Anybody knows, how can I do paging with Struts??? (Previous 1 - 2 - 3 ... Next) And changing the color of the rows on the table each iteration? Is there any Tag Lib who do this??? Tanks!!! []s Mauricio - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
http://displaytag.sourceforge.net/ (my favorite, new 1.0 beta out) http://jsptags.com/tags/navigation/pager/index.jsp HTH, -- Chris - Original Message - From: Frederic Dernbach [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Monday, November 03, 2003 12:59 PM Subject: Re: Paging Mauricio, You can look at 'struts-layout' : http://struts.application-servers.com/ It is a quite powerful taglib that includes, among other stuff, paging management. Fred Le lun 03/11/2003 12:43, Mauricio T. Ferraz a crit : Hi People!!! Anybody knows, how can I do paging with Struts??? (Previous 1 - 2 - 3 ... Next) And changing the color of the rows on the table each iteration? Is there any Tag Lib who do this??? Tanks!!! []s Mauricio - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
Christian Bollmeyer wrote: http://displaytag.sourceforge.net/ (my favorite, new 1.0 beta out) The last time I used this tag was a long time ago (over 5 months). What I didn't like about it, at the time, was that it stored your entire collection in session scope. This is ok for small to moderate sized collections of light objects, but if you want paging where you end up with a new query to bring back your objects then you'll have to implement something else. -- Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
Hi Visit this URL, it works great with struts or any jsp framework http://kulkarni_ash.tripod.com/howto/jsptaglib-howto.html Ashish --- Mauricio T. Ferraz [EMAIL PROTECTED] wrote: Hi People!!! Anybody knows, how can I do paging with Struts??? (Previous 1 - 2 - 3 ... Next) And changing the color of the rows on the table each iteration? Is there any Tag Lib who do this??? Tanks!!! []´s Mauricio __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
- Original Message - From: Rick Reumann [EMAIL PROTECTED] To: Struts Users Mailing List [EMAIL PROTECTED] Sent: Monday, November 03, 2003 3:29 PM Subject: Re: Paging Christian Bollmeyer wrote: http://displaytag.sourceforge.net/ (my favorite, new 1.0 beta out) The last time I used this tag was a long time ago (over 5 months). What I didn't like about it, at the time, was that it stored your entire collection in session scope. This is ok for small to moderate sized collections of light objects, but if you want paging where you end up with a new query to bring back your objects then you'll have to implement something else. Definitely, but then, most paging solutions that work on Collections do the same, including the JSTL approach described here in more detail: http://developer.java.sun.com/developer/Books/javaprogramming/jstl/jstl_chap 05.pdf Then, a grep on the 1.0-b1 source tree for 'session' shows only two references (both of them in mere utility functions), so I think the Collection doesn't necessarily have to be exactly in Session scope, but can be in any scope. Probably Matt Raible can shed more light on this matter. But what do you recommend? I saw there's a paginatedList feature in iBATIS, but I don't have any experience with it yet. -- Rick -- Chris. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
Ashish Kulkarni wrote: Visit this URL, it works great with struts or any jsp framework http://kulkarni_ash.tripod.com/howto/jsptaglib-howto.html Yea page not found errors work great with any framework, I agree:0 -- Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Paging
Rick, I started using the 1.0 beta 2 this weekend and it's full of impressive changes including fixed exports so it works with page breaks (previously, it only exported what was on the screen). About your copying of objects, the docs say that copying will happen if you let the tags sort the objects instead of using in the natural order it was saved into scope (request, session, application). However, it shouldn't be that bad since it is lists and iterators and will should only be address references for the copy into a new list/Iterator it sorts with, I think. To be sure, ask on their user list: http://www.mail-archive.com/index.php?hunt=displaytag Regards, David -Original Message- From: Rick Reumann [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2003 9:29 AM To: Struts Users Mailing List Subject: Re: Paging Christian Bollmeyer wrote: http://displaytag.sourceforge.net/ (my favorite, new 1.0 beta out) The last time I used this tag was a long time ago (over 5 months). What I didn't like about it, at the time, was that it stored your entire collection in session scope. This is ok for small to moderate sized collections of light objects, but if you want paging where you end up with a new query to bring back your objects then you'll have to implement something else. -- Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
- Original Message -
From: Rick Reumann [EMAIL PROTECTED]
To: Struts Users Mailing List [EMAIL PROTECTED]
Sent: Monday, November 03, 2003 4:46 PM
Subject: Re: Paging
Ashish Kulkarni wrote:
Visit this URL, it works great with struts or any jsp
framework
http://kulkarni_ash.tripod.com/howto/jsptaglib-howto.html
Yea page not found errors work great with any framework, I agree:0
--
Rick
?? Well, no problems from here, at least. As it's short
enough, I'll just post it here:
Using JSP taglib for paging
Step 1 download jsp taglib from
http://jsptags.com/tags/navigation/pager/download.jsp
Step 2
Copy pager-taglib.tld in WEB-INF directory of web application
Copy pager-taglib.jar in WEB-INF/lib directory of web application
Step 3 Define tld in web.xml
taglib
taglib-urihttp://jsptags.com/tags/navigation/pager/taglib-uri
taglib-location/WEB-INF/pager-taglib.tld/taglib-location
/taglib
Step 4 Define the tag lib in jsp
%@ taglib uri=/WEB-INF/pager-taglib.tld prefix=pg %
Step 5 Define number of pages to display etc in jsp
pg:pager maxIndexPages=10
maxPageItems=10 export=pagerPageNumber=pageNumber
!-- pagerPageNumber is used by me in the logic to display
the current page in different color with out link--
Step 6 Create a loop for displaying data
% while (crs.next())
!-where crs is cached row set, this object must be ArrayList,
Vector, Collection, ResultSet which can be scrolled --
pg:item
{ %
% out.print(crs.getString(L820FIRM).trim()); %
% } %
/pg:item
Step 7 Logic to display the page numbers and next page
and previous page arrows for navigation
pg:index
pg:prev
a href=%=pageUrl% !-- some image text to display navigation to
previous page --/a
/pg:prev
pg:pages
if (pageNumber == pagerPageNumber)
{
// same page so no link here
%=pageNumber%
} else
{
// other pages where the user can jump
a href=%=pageUrl% %= pageNumber %/a
}
/pg:pages
pg:next
a href=%=pageUrl% !-- some image text to display navigation to next
page --/a
/pg:next
/pg:index
Step 8 end of pager taglib
/pg:pager
More documentation can be found at
http://jsptags.com/tags/navigation/pager/pager-taglib-2.0.html
HTH,
-- Chris.
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
Christian Bollmeyer wrote: But what do you recommend? I saw there's a paginatedList feature in iBATIS, but I don't have any experience with it yet. -- You have to use 3 things together: 1. Display tag pagination (good for thousands of rows, maybe all you need, I store in request scope, let iBatis cache for all users that run same querry at Model layer) 2. iBatis pagination and most important you did not mention: #3: Sql select * from tableX limit 1000 offset 2 order by date (good for unlimited # of rows, cached by ibatis implicitly) Than you have a nice scaleable google like pagination. -- Chris. -- Victor Cekvenich, Struts Instructor (215) 321-9146 Advanced Struts Training http://basebeans.com/do/cmsPg?content=TRAINING Server Side Java training with Rich UI, mentoring, designs, samples and project recovery in North East. Simple best practice basic Portal, a Struts CMS, Membership, Forums, Shopping and Credit processing, http://basicportal.com software, ready to develop/customize; requires a db to run. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging
hello rick, i am also using the beta version, undoubtly it works great(wonderful work matt!!!) but even now the problem with the export is that in case its someone under one of the tiles. there is no way to set the content-type once the page has been loaded and hence the xml/cvs/excel export in stuffed someone in the html code for the rest of the page. i had one workaround for this, using a jsp with only the same display tag. and since its an export the page isnt (visibly) loaded and i get the save as dialog box. in case u had a similar problem, and u came up with a better solution do let me know thanks. David Friedman wrote: Rick, I started using the 1.0 beta 2 this weekend and it's full of impressive changes including fixed exports so it works with page breaks (previously, it only exported what was on the screen). About your copying of objects, the docs say that copying will happen if you let the tags sort the objects instead of using in the natural order it was saved into scope (request, session, application). However, it shouldn't be that bad since it is lists and iterators and will should only be address references for the copy into a new list/Iterator it sorts with, I think. To be sure, ask on their user list: http://www.mail-archive.com/index.php?hunt=displaytag Regards, David -Original Message- From: Rick Reumann [mailto:[EMAIL PROTECTED] Sent: Monday, November 03, 2003 9:29 AM To: Struts Users Mailing List Subject: Re: Paging Christian Bollmeyer wrote: http://displaytag.sourceforge.net/ (my favorite, new 1.0 beta out) The last time I used this tag was a long time ago (over 5 months). What I didn't like about it, at the time, was that it stored your entire collection in session scope. This is ok for small to moderate sized collections of light objects, but if you want paging where you end up with a new query to bring back your objects then you'll have to implement something else. -- Rick - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Rajat Pandit | [EMAIL PROTECTED] +91 612 3117606 [ Developer and Part Time Human Being] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Paging through DB ResultSets
Model Layer If you database supports *limit* clause, use that. OR Use Paging Patterns (known as Value List Handler in J2EE but i think it's misnomer ;-) Presentation Layer Use Pager Taglib |-Original Message- |From: Kapadia Mitesh-C23457 [mailto:[EMAIL PROTECTED] |Sent: Tuesday, August 26, 2003 1:53 AM |To: [EMAIL PROTECTED] |Subject: Paging through DB ResultSets | | |Any suggestions or ideas on how I can page through a DB ResultSet? | |Thanks in advance. | |- Mitesh | - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
RE: Paging a collection property
Hi, I have built some thing similar... And if u are using u r own tag to built pagination, this should be simple... What u should be doing is use indexed properties(keep a collection of beans in form..)And in u r tag build indexed parameter names on page. html:text name=MyForm property=%=\beanList[\+i+\].Name\%/ Here MyForm has indexed getters and setters for the beans. Hopw this helps, regards, Shirish -Original Message- From: Jorge Mascena [mailto:[EMAIL PROTECTED] Sent: Monday, March 24, 2003 8:06 PM To: 'Struts Users Mailing List' Subject: RES: Paging a collection property Sorry if I didn't explain the problem better. The pagination itself is ok (I've built a taglib that's equivalent to the one you pointed me). My question is how I can bind the input fields generated by the html and/or nested tags to the underlying objects so that any change the user makes to the input fields will be reflected on the properties of the corresponding books (to use the same example from the original message). Say the user is on page 2 and each page has 10 books. He changes the title of the first book of the page and submits the form. I want to know if struts will be smart enough to update the title of the 11th book and not the 1st book of the collection of books of the author. If so, what do I have to do to accomplish that? Thanks Jorge Mascena -Mensagem original- De: Vic Cekvenich [mailto:[EMAIL PROTECTED] Enviada em: Monday, March 24, 2003 3:22 PM Para: [EMAIL PROTECTED] Assunto: Re: Paging a collection property Look at display tag in google. hth, .V Jorge Mascena wrote: I need some directions on how to use the struts html and/or neste taglibs to handle the case where there's a collection property of a form bean that may contain a big number of objects. In this case, I'd like to able to do some sort of paging on these objects and I'd like to know if struts have any support for that. For example: I have a form bean, AuthorFormBean, that has a collection of books he wrote. I can use the nested taglib to render the book collection, so the user can fill the books data from the same form he fills the rest of the data about the author. So far, so good. The problem (or question) is: what if the number of books gets too big and I want to split these books into pages (and have a navigator for those pages), but they still belong to the same form bean, so no matter which page the user is, the nested tags (nested:text, for example) will know the correct index of the objects we're talking about (if we're on page 2 and each page has 10 books, the nested tags will start getting the objects from index 9 and not 0, and so on) and properly populates the input fields and updates the corresponding objects when loading and submiting the form respectively. I know how to do it directly with pure html code, but I'd like to know if it would be possible to get some advantage on using struts for this matter. I hope I could make myself clear. Thanks for any help. Jorge Mascena - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging a collection property
Look at display tag in google. hth, .V Jorge Mascena wrote: I need some directions on how to use the struts html and/or neste taglibs to handle the case where there's a collection property of a form bean that may contain a big number of objects. In this case, I'd like to able to do some sort of paging on these objects and I'd like to know if struts have any support for that. For example: I have a form bean, AuthorFormBean, that has a collection of books he wrote. I can use the nested taglib to render the book collection, so the user can fill the books data from the same form he fills the rest of the data about the author. So far, so good. The problem (or question) is: what if the number of books gets too big and I want to split these books into pages (and have a navigator for those pages), but they still belong to the same form bean, so no matter which page the user is, the nested tags (nested:text, for example) will know the correct index of the objects we're talking about (if we're on page 2 and each page has 10 books, the nested tags will start getting the objects from index 9 and not 0, and so on) and properly populates the input fields and updates the corresponding objects when loading and submiting the form respectively. I know how to do it directly with pure html code, but I'd like to know if it would be possible to get some advantage on using struts for this matter. I hope I could make myself clear. Thanks for any help. Jorge Mascena - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: Paging using struts
Pat Quinn wrote: Does anyone have a good example of Paging using struts?? _ The new MSN 8 is here: Try it free* for 2 months http://join.msn.com/?page=dept/dialup -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] . pager-taglib-1.1.jar Description: Binary data -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Paging using struts
http://jsptags.com/tags/navigation/pager/pager-demo.jsp Pat Quinn wrote: Does anyone have a good example of Paging using struts?? _ The new MSN 8 is here: Try it free* for 2 months http://join.msn.com/?page=dept/dialup -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] . -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Paging using struts
I don't think struts has any paging functionality available out of the box. What you can do is looking into Sun's design pattern in the petstore codebase and learn from there. Basically, you can use JDBC like this stmt = conn.prepareStatement(sqlString, ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY ); to archive what you want. Hope this helps -Original Message- From: Pat Quinn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 1:33 PM To: [EMAIL PROTECTED] Subject: Paging using struts Does anyone have a good example of Paging using struts?? _ The new MSN 8 is here: Try it free* for 2 months http://join.msn.com/?page=dept/dialup -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] _ Introducing the all new and improved continental.com. With a totally new personalized design, it's the best place to go. Before you go. Continental Airlines. Work Hard. Fly Right. http://www.continental.com -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Paging using struts
so far I never used it, but I read about it on this group and put it on my pending list: http://edhill.its.uiowa.edu/display-examples-0.8/example-paging.jsp -Original Message- From: Pat Quinn [mailto:[EMAIL PROTECTED]] Sent: Dienstag, 14. Januar 2003 20:33 To: [EMAIL PROTECTED] Subject: Paging using struts Does anyone have a good example of Paging using struts?? _ The new MSN 8 is here: Try it free* for 2 months http://join.msn.com/?page=dept/dialup -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: Paging using struts
You can find more info about pager tag here: http://jsptags.com/tags/navigation/pager/index.jsp -Original Message- From: Pat Quinn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 2:33 PM To: [EMAIL PROTECTED] Subject: Paging using struts Does anyone have a good example of Paging using struts?? _ The new MSN 8 is here: Try it free* for 2 months http://join.msn.com/?page=dept/dialup -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
RE: paging taglib and struts?
Malcolm I've been reading throughthe documentation for the taglib, and I'm getting the impression that the collectionof things I'm interating over has to exist in it's entirety in server memory. Is that true? This is slightly problematic for me because it's a large collection of data (I know, I should push back on the user...it's along story) My questions are 1. how does it know what the collection is that I'm iterating through 2. what are you using the pg:param name=action value=search/ for? currently ,y I've included my jsp for reference... Any help is appreciated. John Mattos Sr. Developer and Architect iNDEMAND 345 Hudson St. 16th Floor New York, New York 10014 --- My JSP--- pg:pager TABLE border=1 TBODYtr th colspan=13 align=centerView Valid Transactions/th/tr TR TR ThType/Th ThStatus/Th ThOrg Id/Th ThOrg Name/Th ThChannel/Th ThProduct Title/Th ThSignal Type/Th ThEvent #/Th ThDeal/Th ThRetail/Th ThBuys/Th ThAmount Due/Th ThPost Date/Th /TR pg:item logic:iterate id=buyTransaction type=com.indemand.indab.application.invoice.BuyTransaction collection=%=valids% TR TD ALIGN=LEFT%=buyTransaction.getType()%nbsp;/TD TD ALIGN=LEFT%=buyTransaction.getStatus()%nbsp;/TD TD ALIGN=RIGHT%=buyTransaction.getOrgId()%/TD TD ALIGN=LEFT%=buyTransaction.getAffiliateFullName().trim()%nbsp;/TD TD ALIGN=RIGHT%=buyTransaction.getChannel()%nbsp;/TD TD ALIGN=LEFT%=buyTransaction.getAssetTitle()%nbsp;/TD TD ALIGN=CENTER%=buyTransaction.getTiertype()%nbsp;/TD TD ALIGN=RIGHT%=buyTransaction.getIndAsstId()%nbsp;/TD TD ALIGN=RIGHT%=buyTransaction.getDealTerm()%nbsp;/TD TD ALIGN=RIGHT$%=buyTransaction.getTransAmt()%nbsp;/TD TD ALIGN=RIGHT%=buyTransaction.getBuys()%nbsp;/TD TD ALIGN=RIGHT$%=buyTransaction.getTotalTransAmt()%/TD TD ALIGN=CENTER%=buyTransaction.getPostDate()%nbsp;/TD /TR /logic:iterate /pg:item TR TD colspan=13 Align=centernbsp; pg:index pg:prev a href=%= pageUrl %[ (%= pageNumber %) Previous ]/a /pg:prev pg:pages a href=%= pageUrl %%= pageNumber %/a /pg:pages pg:next a href=%= pageUrl %[ Next (%= pageNumber %) ]/a /pg:next /pg:index /pg:pager /TD /TR /table --- END --- -Original Message- From: Malcolm Wise [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 4:32 AM To: 'Struts Users Mailing List' Subject: RE: paging taglib and struts? John, I am using this taglib quite extensively and it works very well with Struts. Below is a fairly basic example jsp. Essentially, the pager url attribute specifies the destination when any of the navigation links is clicked. Request parameters required by the action class can be specified using the param tag. These can be literals (value=search) as in my example or use bean:define and specify the value attribute as the resulting variable (value=%=expr%). The item tag defines each row to be displayed, and needs to be enclosed within logic:iterate. The index tag defines the navigation bar (prev, next etc) as a series of hyperlinks. The maxIndexPages attribute of the pager tag defines how many page numbers will be displayed in the navigation bar, i.e the below example will display [Prev] 1 2 3 4 5 6 7 8 9 10 [Next] assuming there are 10 pages worth of data. [Prev] and [Next] only display if there are previous or more pages. The maxPageItems attribute specifies how many detail rows per page to be displayed. I'm happy to answer any further questions or give examples. Cheers Malc pg:pager url=AdvancedSearch.do maxIndexPages=10 maxPageItems=15 pg:param name=action value=search/ TABLE width=100% TR TD align=center TABLE width=60% border=0 TR TH width=10%bean:message key=partnum.ecnsearchresults.ecnid//TH TH width=20%bean:message key=partnum.ecnsearchresults.model//TH TH width=10%bean:message key=partnum.ecnsearchresults.releasedate//TH TH width=10%bean:message key=partnum.ecnsearchresults.status//TH /TR logic:iterate id=row name=results scope=request type
RE: paging taglib and struts?
You would need to calculate the total number of rows which are to be displayed and put this into the request/session for the jsp to use. Thanks for the tip. The pager docs don't actually say this it is sorta assumed. Docs could be alot better. -Original Message- From: Malcolm Wise [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 06, 2002 9:31 AM To: 'Struts Users Mailing List' Subject: RE: paging taglib and struts? Pedro, (Posted here 'cos I couldn't get through to your email address.) Refer to the taglib documentation at http://jsptags.com/tags/navigation/pager/pager-taglib-1.1.html I think you would have to do some arithmetic in your Action class and put the results into the request/session to achieve this. The 'pager' tag makes available a pagerPageNumber variable which is the page number of the current page. Internally the tag library classes must know how many rows and pages there are, but it does not expose these to the jsp as far as I can see. You would need to calculate the total number of rows which are to be displayed and put this into the request/session for the jsp to use. So, to get the total number of pages you would need to work out the no. of rows to display divided by the value specified for the maxPageItems attribute of the 'pager' tag (+1 if there is a remainder). The pagerOffset variable exposed by the 'pager' tag can be used to calculate the Results 1 to 10 part of your requirement (pagerOffset +1 to pagerOffset+maxPageItems, unless this is the last page, in which case it would be pagerOffset +1 to total no. of rows). Another option would be to ask the author (James Klicman, I believe - [EMAIL PROTECTED]) to modify the tag classes to expose the variables you need ( I don't think this library is open source). HTH Malc -Original Message- From: Pedro Marques [mailto:[EMAIL PROTECTED]] Sent: 05 February 2002 22:15 To: [EMAIL PROTECTED] Subject: RE: paging taglib and struts? Malcolm, Is it possible to get the total number of pages? I would like a navigation bar like this: Results 1 to 10 out of 1036page 1/20 thanks, Pedro. -Original Message- From: Malcolm Wise [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 1:32 AM To: 'Struts Users Mailing List' Subject: RE: paging taglib and struts? John, I am using this taglib quite extensively and it works very well with Struts. Below is a fairly basic example jsp. Essentially, the pager url attribute specifies the destination when any of the navigation links is clicked. Request parameters required by the action class can be specified using the param tag. These can be literals (value=search) as in my example or use bean:define and specify the value attribute as the resulting variable (value=%=expr%). The item tag defines each row to be displayed, and needs to be enclosed within logic:iterate. The index tag defines the navigation bar (prev, next etc) as a series of hyperlinks. The maxIndexPages attribute of the pager tag defines how many page numbers will be displayed in the navigation bar, i.e the below example will display [Prev] 1 2 3 4 5 6 7 8 9 10 [Next] assuming there are 10 pages worth of data. [Prev] and [Next] only display if there are previous or more pages. The maxPageItems attribute specifies how many detail rows per page to be displayed. I'm happy to answer any further questions or give examples. Cheers Malc pg:pager url=AdvancedSearch.do maxIndexPages=10 maxPageItems=15 pg:param name=action value=search/ TABLE width=100% TR TD align=center TABLE width=60% border=0 TR TH width=10%bean:message key=partnum.ecnsearchresults.ecnid//TH TH width=20%bean:message key=partnum.ecnsearchresults.model//TH TH width=10%bean:message key=partnum.ecnsearchresults.releasedate//TH TH width=10%bean:message key=partnum.ecnsearchresults.status//TH /TR logic:iterate id=row name=results scope=request type=com.sony.sde.sql.Row pg:item TR TDbean:write name=row property=string[1]//TD TDbean:write name=row property=string[2]//TD TDbean:write name=row property=string[3]//TD TDbean:write name=row property=string[4]//TD /TR /pg:item /logic:iterate /TABLE TABLE width=60% border=0 TRTDnbsp;/TD/TR TR align=center TD pg:index pg:preva href=%=pageUrl%[ Prev]/a /pg:prev pg:pages bean:define id=pageNo value=%=pagerPageNumber.toString()%/ logic:equal name=pageNo value=%=pageNumber.toString()% %=pageNumber% /logic:equal
RE: paging taglib and struts?
John, I am using this taglib quite extensively and it works very well with Struts. Below is a fairly basic example jsp. Essentially, the pager url attribute specifies the destination when any of the navigation links is clicked. Request parameters required by the action class can be specified using the param tag. These can be literals (value=search) as in my example or use bean:define and specify the value attribute as the resulting variable (value=%=expr%). The item tag defines each row to be displayed, and needs to be enclosed within logic:iterate. The index tag defines the navigation bar (prev, next etc) as a series of hyperlinks. The maxIndexPages attribute of the pager tag defines how many page numbers will be displayed in the navigation bar, i.e the below example will display [Prev] 1 2 3 4 5 6 7 8 9 10 [Next] assuming there are 10 pages worth of data. [Prev] and [Next] only display if there are previous or more pages. The maxPageItems attribute specifies how many detail rows per page to be displayed. I'm happy to answer any further questions or give examples. Cheers Malc pg:pager url=AdvancedSearch.do maxIndexPages=10 maxPageItems=15 pg:param name=action value=search/ TABLE width=100% TR TD align=center TABLE width=60% border=0 TR TH width=10%bean:message key=partnum.ecnsearchresults.ecnid//TH TH width=20%bean:message key=partnum.ecnsearchresults.model//TH TH width=10%bean:message key=partnum.ecnsearchresults.releasedate//TH TH width=10%bean:message key=partnum.ecnsearchresults.status//TH /TR logic:iterate id=row name=results scope=request type=com.sony.sde.sql.Row pg:item TR TDbean:write name=row property=string[1]//TD TDbean:write name=row property=string[2]//TD TDbean:write name=row property=string[3]//TD TDbean:write name=row property=string[4]//TD /TR /pg:item /logic:iterate /TABLE TABLE width=60% border=0 TRTDnbsp;/TD/TR TR align=center TD pg:index pg:preva href=%=pageUrl%[ Prev]/a /pg:prev pg:pages bean:define id=pageNo value=%=pagerPageNumber.toString()%/ logic:equal name=pageNo value=%=pageNumber.toString()% %=pageNumber% /logic:equal logic:notEqual name=pageNo value=%=pageNumber.toString()% a href=%= pageUrl %%= pageNumber %/a /logic:notEqual /pg:pages pg:nexta href=%= pageUrl %[Next ]/a /pg:next /pg:index /TD /TR /TABLE /TD /TR /TABLE /pg:pager -Original Message- From: John Menke [mailto:[EMAIL PROTECTED]] Sent: 03 March 2002 02:08 To: struts-user Subject: paging taglib and struts? Does anyone any suggestions for implementing paging with struts? I have searched the archive and karl basel posted this: snip There's a good pager taglib at jsptags.com. I've used it in a struts app and does the job quite well when embedded in the iterate tags. logic:iterate pg:item Item Details /pg:item /logic:iterate snip I have downloaded this pager and the documentation is not providing enough information on how this works. Are there any examples out there on how to do this that I am missing? -john -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED] * The information contained in this message or any of its attachments may be privileged and confidential and intended for the exclusive use of the addressee. If you are not the addressee any disclosure, reproduction, distribution or other dissemination or use of this communication is strictly prohibited * -- To unsubscribe, e-mail: mailto:[EMAIL PROTECTED] For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: paging for web application
On Wed, 31 Jan 2001, Peter Alfors wrote: check out the pager taglib: http://jsptags.com/tags/navigation/pager/ Very handy! For anyone else looking at this for paging long-winded result sets, and using Tomcat 4.0-b1, I needed to edit the demo "pager-demo.jsp" and change: pg:pager maxIndexPages="%= 20 %" to: pg:pager maxIndexPages="20" This fixes a hack put in to convert "20" to an int as delineated in the pager troubleshooting section.
Re: paging for web application
On Wed, 31 Jan 2001, Peter Alfors wrote: check out the pager taglib: http://jsptags.com/tags/navigation/pager/ Actually, I can run the example that comes with the distribution but am having some problems using this pager taglib in Struts. The links created by the pager aren't working. The example I'm working on has a JSP with an embedded form that, upon submission, invokes a database query and reads back the results stored in request scope beans (to the same JSP). The pager creates the correct number of links to result pages. For example, one link created is: http://localhost/project/simpleQuery.jsp?pager.offset=1 But when I click on this link I only get my simple query form and the pager output of: Result Pages [Prev] 1 but no other results. I've also tried typing in the URL: http://localhost/project/simpleQuery.do?pager.offset=1 with the same result (or lack there-of). Ideas? Any help is appreciated! Sorry if this is off-topic for Struts.
Re: paging for web application
On Mon, 12 Feb 2001, Steve A Drake wrote: On Wed, 31 Jan 2001, Peter Alfors wrote: check out the pager taglib: http://jsptags.com/tags/navigation/pager/ Actually, I can run the example that comes with the distribution but am having some problems using this pager taglib in Struts. The links created by the pager aren't working. Well, I did get this working but with a couple of major caveats. 1) In order to define a given pg:index, I had to use scriptlets for all the code between the start and end tag. I assume this is because - from what someone enlightened me earlier with - you can't nest tags. I hope I'm wrong about this because it significantly clutters up the JSP and renders all the bean tags unusable. =:| 2) I needed to locate the hypertext index at the bottom of the document because the index dimensions are determined as the results are iterated. I assume this could be fixed by buffering the output to a StringBuffer or somesuch but havn't tried that yet. If anyone has some usage suggestions for this pager taglib, I'd appreciate your input.
Re: paging for web application
Misak, I've found the pager tag that James over at http://www.jsptags.com has developed is quite powerful and usable. I've used it in some prototypes using Struts and Tomcat. One of my colleagues attempted to get it to work under Weblogic without much luck, but we didn't spend much time on it. Now I'm just waiting for him to make the taglib that generates his menu available :-) Here's the link http://jsptags.com/tags/navigation/pager This topic does beg the question whether Struts should have its own paging tags... I suspect you can probably implement paging with the standard logic and iteration tags though... Regards, James W. -- This e-mail is from Cards Etc Pty Ltd (ACN: 069 533 302). It may contain privileged and confidential information. It is intended for the named recipient(s) only. If you are not an intended recipient, please notify us immediately by reply e-mail or by phone on +61 2 9212 7773 delete this e-mail from your system. --
Re: paging for web application
check out the pager taglib: http://jsptags.com/tags/navigation/pager/ "Boulatian, Misak" wrote: Hi alI, I am trying to implement paging for web application. The query may return over thousand records and it is a bad idea to dump all of those to the client. I was thinking to feed only 50 records at a time and have client to click for next or previous page. We are using struts with EJBs. Our action classes call session EJBs, which return information as a javabean. Does anyone have any ideas or done anything with struts in regards to paging (it may not even have to do anything with struts). I appreciate any responses. Thanks, Misak begin:vcard n:; x-mozilla-html:FALSE org:BRIMG SRC="http://www.irista.com/logo/irista.gif"BRBRFONT Color=#80FONT SIZE=2BBringing Vision to Your Supply Chain adr:;; version:2.1 end:vcard
