Thanks everyone for the various solutions. My favorite was Andy's. Nice and clean, and minimal impact on the code I had already written.
Andy, you win your choice of prizes from our infamous prize closet! :) Andy Matthews wrote: > SELECT year(date) as year, Month(date) as month, Day(date) as day > FROM yourtable > ORDER BY year, month, day > > then simply use the group attribute of cfoutput. > > <!----------------//------ > andy matthews > web developer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > -----Original Message----- > From: Ray Champagne [mailto:[EMAIL PROTECTED] > Sent: Thursday, April 20, 2006 9:13 AM > To: CF-Talk > Subject: grouping by date > > > I have an event table that I need to output the data in a specific > fashion, based on dates, like so: > > April > 19th > event1 > event2 > event3 > 26th > event4 > event5 > 30th > event6 > event7 > event8 > May > 1st > event10 > event11 > 17th > event12 > > June > > etc > > I have the date stored as a date type in the DB. What's the best way to > go about outputting the events, grouped as above? I've come up with > some elaborate workarounds, but they seem clunky and not very > maintenance-friendly. > > For argument's sake, let's say the current select statement looks like this: > > SELECT startdate, event_title > FROM events > WHERE active=1 > ORDER BY startdate ASC > > Thanks, > > Ray > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238296 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54