Thank you! That may have what I was looking for. This will be my first venture outside of the standard tag library.
Even if it doesn't, it's a nice tool that will make my tables look much nicer! :) Keith ---------- Original Message ----------- From: "Francois Beausoleil" <[EMAIL PROTECTED]> To: "Tag Libraries Users List" <[EMAIL PROTECTED]>, "'Tag Libraries Users List'" <[EMAIL PROTECTED]> Sent: Thu, 15 Apr 2004 15:08:42 -0400 Subject: RE: Conditional Loop > Keith, take a look at the Display Tag library http://displaytag.sf.net > > It provides a grouping function where a column's value is not repeated if > it is the same as the value in the row above. > > Hope that helps ! > François > > On Thu, 15 Apr 2004 15:07:20 -0400, "David Schwartz" <[EMAIL PROTECTED]> > said: > > >> Isn't there any way to do this via JSTL and not in the DB query? > > Maybe, but I'm not sure why you would want to. Seems like the > > functionality > > you describe is a feature of the DB. > > Also, with JSTL & 30+ columns could be a lot of coding. > > > > Do you have more specific example? What db? > > > > David Schwartz > > > > -----Original Message----- > > From: Keith [mailto:[EMAIL PROTECTED] > > Sent: Thursday, April 15, 2004 2:28 PM > > To: Tag Libraries Users List > > Subject: RE: Conditional Loop > > > > Isn't there any way to do this via JSTL and not in the DB query? My > > example > > was rather > > simplistic for what I'm really doing, but still is a good example of the > > raw > > data. I'm > > using the resulting number in colspans and rowspans to build a nicer > > table > > layout > > (displaying data only once that's repeated for several rows). I was > > trying > > to avoid sub > > selects and such because I have anywhere from 30 and up columns that I'm > > returning and > > having to store a separate count variable for each one is getting > > ridiculous. I really do > > appreciate your time in replying, though! > > > > Keith > > > > > > > > ---------- Original Message ----------- > > From: David Schwartz <[EMAIL PROTECTED]> > > To: "'Tag Libraries Users List'" <[EMAIL PROTECTED]> > > Sent: Thu, 15 Apr 2004 14:23:03 -0400 > > Subject: RE: Conditional Loop > > > > > Try a sub select that returns the count... > > > > > > SELECT > > > > > > t.Primary_Key, > > > h.Name, > > > (Select Count(tt.Name) as Count_Name > > > FROM myTable tt > > > where tt.Name = t.Name > > > ) > > > FROM myTable tt > > > > > > It's fast & returns all nesc data from the db. > > > > > > David Schwartz > > > > > > -----Original Message----- > > > From: Keith [mailto:[EMAIL PROTECTED] > > > Sent: Thursday, April 15, 2004 1:45 PM > > > To: Taglibs > > > Subject: Conditional Loop > > > > > > Here's a generic scenario similar to my situation: > > > > > > A database with two columns, one being an auto-sequence number for the > > > primary key, the > > > other listing names. > > > > > > 1 Bob > > > 2 Bob > > > 3 Jim > > > 4 John > > > 5 Jim > > > 6 Bob > > > 7 John > > > 8 John > > > 9 Jim > > > 10 Bob > > > > > > Ok, I query the database to return both columns, since I need all the > > stored > > > data. But I > > > also want to get the number of each unique name in the 'names' column (how > > > many Jim's, > > > how many Bob's, and how many John's). I know I could do a separate query > > > looking for a > > > count() on each unique name, but that's not realistic with the amount of > > > data I'm dealing > > > with (actually tried doing it and nearly killed the poor DB server). > > > > > > Normally, I'd do this with a 'while' conditional loop and a counter > > > incrementing while > > > the 'name' column contains a specific value, but I don't see that > > > functionality in JSTL. > > > I had asked generally before if JSTL had any 'while' loop capability, but > > > got no > > > response. So, I figured I'd give an example of what I'm trying to do and > > > maybe someone > > > could help. > > > > > > Thanks! > > > > > > Keith > > > > > > --------------------------------------------------------------------- > > > 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] > > ------- End of Original Message ------- > > > > > > --------------------------------------------------------------------- > > 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] > > > Developer of Java Gui Builder > http://jgb.sourceforge.net/ > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] ------- End of Original Message ------- --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
