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:238285 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
