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