Re: Paging for table...

[HK Santosh]

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 attachment

Re: Paging for table...

[Ed Dowgiallo]

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
> 

RE: Paging for table...

[Adolfo Miguelez]

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

RE: Paging for table...

[rahul.chaudhary]

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 for table...

[David Friedman]

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...

[rahul.chaudhary]

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...

[David Friedman]

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:


  
  
  
  
  


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...

[vasudevrao gupta]

.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...

[David Friedman]

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

[Rajat Pandit]

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

[Vic Cekvenich]

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
 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,  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

[Christian Bollmeyer]

- 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


http://jsptags.com/tags/navigation/pager
/WEB-INF/pager-taglib.tld


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





Step 6 Create a loop for displaying data

<% while (crs.next())


 { %>
<% out.print(crs.getString("L820FIRM").trim()); %>
<% } %>


Step 7 Logic to display the page numbers and next page
  and previous page arrows for navigation



 < 



if (pageNumber == pagerPageNumber)
{
// same page so no link here
<%=pageNumber%>
} else
{
// other pages where the user can jump
<%= pageNumber %>
}



 --  > > 
 



Step 8 end of pager taglib



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

[David Friedman]

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

[Rick Reumann]

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

[Christian Bollmeyer]

- 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]

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???
> (<>) 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

[Rick Reumann]

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

[Christian Bollmeyer]

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??? (<>) 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

[Frederic Dernbach]

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??? (<>) 
> 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 through DB ResultSets

[Navjot Singh]

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

[shirishchandra.sakhare]

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.

"/>

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 (, 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

[Vic Cekvenich]

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 (, 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

[Gabrovsky, Ivaylo]

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:

For additional commands, e-mail:


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: Paging using struts

[René Eigenheer]

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:
> 
> For additional commands, e-mail:
> 
>
>


--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: Paging using struts

[Hoang, Hai]

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:

For additional commands, e-mail:



_
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:   
For additional commands, e-mail: 

Re: Paging using struts

[Gus Delgado]

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:   

For additional commands, e-mail: 



.





--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

Re: Paging using struts

[Gus Delgado]

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:   

For additional commands, e-mail: 



.






pager-taglib-1.1.jar
Description: Binary data
--
To unsubscribe, e-mail:   
For additional commands, e-mail: 

RE: paging taglib and struts?

[Mattos, John]

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 ""
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--- 



View Valid Transactions


Type
Status
Org Id
Org Name
Channel
Product Title
Signal Type
Event #
Deal
Retail
Buys
Amount Due
Post Date





<%=buyTransaction.getType()%> 
<%=buyTransaction.getStatus()%> 
<%=buyTransaction.getOrgId()%>
<%=buyTransaction.getAffiliateFullName().trim()%> 
<%=buyTransaction.getChannel()%> 
<%=buyTransaction.getAssetTitle()%> 
<%=buyTransaction.getTiertype()%> 
<%=buyTransaction.getIndAsstId()%> 
<%=buyTransaction.getDealTerm()%> 
$<%=buyTransaction.getTransAmt()%> 
<%=buyTransaction.getBuys()%> 
$<%=buyTransaction.getTotalTransAmt()%>
<%=buyTransaction.getPostDate()%> 






 

  

  [ (<%= pageNumber %>) << Previous ]


   <%= pageNumber %> 


  [ Next >> (<%= pageNumber %>) ]

  




--- 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  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
.  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

[<>]

assuming there are 10 pages worth of data.  [<>] 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


  

   
   
   
 




 
 

   
  
  
  
  
   

 
  
  
  
 
 

[<< Prev]


   
   
   <%=pageNumber%>
   
   
   <%= pageNumber %>
   
 
 [Next >>]
 
  
  
   

 
  
   


-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:



There's a

RE: paging taglib and struts?

[John Menke]

>> 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  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
.  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

[<>]

assuming there are 10 pages worth of data.  [<>] 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


  

   
   
   
 




 
 

   
  
  
  
  
   

 
  
  
  
 
 

[<< Prev]


   
   
   <%=pageNumber%>
   
   
   <%= pageNumber %>
   
 
 [Next >>]
 
  
  
   

 
  
   


-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:



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.


   
   Item Details
   





I have downloaded this pager and the documentation is not provid

RE: paging taglib and struts?

[Malcolm Wise]

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  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
.  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

[<>]

assuming there are 10 pages worth of data.  [<>] 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


  

   
   
   
 




 
 

   
  
  
  
  
   

 
  
  
  
 
 

[<< Prev]


   
   
   <%=pageNumber%>
   
   
   <%= pageNumber %>
   
 
 [Next >>]
 
  
  
   

 
  
   


-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:



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.


   
   Item Details
   





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 

RE: paging taglib and struts?

[Malcolm Wise]

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  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
.  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

[<>]

assuming there are 10 pages worth of data.  [<>] 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


  

   
   
   
 




 
 

   
  
  
  
  
   

 
  
  
  
 
 

[<< Prev]


   
   
   <%=pageNumber%>
   
   
   <%= pageNumber %>
   
 
 [Next >>]
 
  
  
   

 
  
   


-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:



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.


   
   Item Details
   





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:

For additional commands, e-mail:




*
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:   
For additional commands, e-mail: 

Re: paging for web application

[Matthew Harrison]

Hi, 
we've been using the pager tags for a while on a prototype, and I'd like to
extend them with a "first" and "last" tag. We're also doing queries which bring
back many thousands of results. We'll be tuning our SQL later, but it works
fine. Did you put your results in a session attribute?

Also, I'm sure you can nest tags, but I think they have to be written to allow
the jsp compiler to interpret the body rather than just copy it. I need
desperately to get into writing tags to clean up our pages, and the pager taglib
fiddling might just be the intro I need.

As for putting the index above the results, maybe you could have an empty loop
to count the results, show the index, use the pager properties pagerOffset and
pagerMaxItems to display the just results for the current page in a second loop,
and then have a second index below. It does kind of defeat some of the logic
built into the pager tags, though, and it's a bit inefficient.
It's designed for arbitrary iterations, but it would be nice though to be able
to tell it how many things you're display without having to loop through it all,
but it seems fast enough for now. 

Matthew.

 > --
 > Date: Mon, 12 Feb 2001 15:36:05 -0700 (MST)
 > To: [EMAIL PROTECTED]
 > From: Steve A Drake <[EMAIL PROTECTED]>
 > Subject: Re: paging for web application
 > Message-ID: <[EMAIL PROTECTED]>
 > 
 > 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 [< 
 > 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.
 > 
 > --
 > 
 > Date: Mon, 12 Feb 2001 17:25:18 -0700 (MST)
 > To: [EMAIL PROTECTED]
 > From: Steve A Drake <[EMAIL PROTECTED]>
 > Subject: Re: paging for web application
 > Message-ID: <[EMAIL PROTECTED]>
 > 
 > 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 , 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

[Steve A Drake]

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 , 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

[Steve A Drake]

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 [

Re: paging for web application

[Steve A Drake]

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:



to:




This fixes a hack put in to convert "20" to an int as delineated in the
pager troubleshooting section.

Re: paging for web application

[JamesW]

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

[Peter Alfors]

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:http://www.irista.com/logo/irista.gif">Bringing Vision to Your Supply Chain
adr:;;
version:2.1
end:vcard