Wow! That is a great function that I didn't even know existed! And how many times have a simply resorted to looping one query over another unnecessarily! And to be able to nest this multiple levels deep is great!
Finally crawling out from under my rock and into the light of day! Doh! On Thu, May 28, 2009 at 11:21 AM, Jason Fisher <ja...@wanax.com> wrote: > > It's actually been there since 4.0, I believe. I know they added the > groupCaseSensitive attribute in 4.5, so the group option was in place by > that point. Essentially it's a way to get your output to follow your SQL > groupings, when that sort of thing is necessary. So like doing a blotter > style calendar, if you ORDER or GROUP the query by eventDate, you can then > cfoutput group="eventDate" to get your day-by-day headings, for example, > and then cfoutput group="eventStartTime" or whatever to do a little block > for each event on the blotter ... etc. They can also be nested deeper: > Company, Department, Individual Employee, for example. > > Jason > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322900 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
