RE: Grouped Output
Shawn,
My principal problem is to avoid repeating the grouped column item on
every detail line on the resulting web page. I only want it to appear on
the first line and list details below it. Can you explain how the group by
clause can help with this formatting?
Thanks.
-Original Message-
From: Shawn Bayern [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 21, 2002 6:47 PM
To: Tag Libraries Users List
Subject: Re: Grouped Output
On Thu, 21 Mar 2002, Zvolensky, Thomas J {PDBI~Nutley} wrote:
Is it possible to generate a grouped report using taglibs without
resorting to using scriptlet logic to determine when the column Name
has changed in the record set?
Why not do it in the SQL itself using a group by clause? I used to
resist database logic too and attempted to do everything in my own
programs, but it's often easier to get the database to manage your data
for you.
--
Shawn Bayern
Author, JSP Standard Tag Library http://www.jstlbook.com
(coming this summer from Manning Publications)
--
To unsubscribe, e-mail:
mailto:[EMAIL PROTECTED]
For additional commands, e-mail:
mailto:[EMAIL PROTECTED]
Grouped Output
I need to generate a report that looks something like this: NameDates Visited --- - Anderau, Eoma 2002-03-07 Andersson, Lisa 2002-02-04 2002-02-25 2002-02-26 2002-03-08 2002-03-13 2002-03-14 2002-01-31 2002-03-15 Aylott, Bridget 2002-01-31 2002-02-18 Is it possible to generate a grouped report using taglibs without resorting to using scriptlet logic to determine when the column Name has changed in the record set? TIA.
Re: Grouped Output
If you use c:set var= to set a variable to the name and then have it
check against it before printing out the name should work. ie,
c:set var=thenamefirst time it's zero length/c:set
c:if test=${oldname != newname}
c:set var=thenamethe name value/c:set
c:out value=${thename}/
/c:if
peter
Zvolensky, Thomas J {PDBI~Nutley} wrote:
I need to generate a report that looks something like this:
NameDates Visited
--- -
Anderau, Eoma 2002-03-07
Andersson, Lisa 2002-02-04
2002-02-25
2002-02-26
2002-03-08
2002-03-13
2002-03-14
2002-01-31
2002-03-15
Aylott, Bridget 2002-01-31
2002-02-18
Is it possible to generate a grouped report using taglibs without
resorting to using scriptlet logic to determine when the column Name has
changed in the record set?
TIA.
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
Re: Grouped Output
On Thu, 21 Mar 2002, Zvolensky, Thomas J {PDBI~Nutley} wrote:
Is it possible to generate a grouped report using taglibs without
resorting to using scriptlet logic to determine when the column Name
has changed in the record set?
Why not do it in the SQL itself using a group by clause? I used to
resist database logic too and attempted to do everything in my own
programs, but it's often easier to get the database to manage your data
for you.
--
Shawn Bayern
Author, JSP Standard Tag Library http://www.jstlbook.com
(coming this summer from Manning Publications)
--
To unsubscribe, e-mail: mailto:[EMAIL PROTECTED]
For additional commands, e-mail: mailto:[EMAIL PROTECTED]
