Hi Ray Add the date parts to your select using date functions e.g. startdate_year, startdate_month and startdate_day.
add a 'group by startdate_year, startdate_month, startdate_day' clause to your query and then take a look at the 'group' attribute on cfoutput. (I've added in year so that spanning a long period will not be ambiguous) Mike T On 4/20/06, Ray Champagne <[EMAIL PROTECTED]> wrote: > > 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:238287 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
