Try:
SELECT MONTH(myDateField) As myMonth FROM ... in your SQL statement. That
should return a column in your result set that just has the month portion of
the date.
Bob
-----Original Message-----
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 7:16 PM
To: CF-Talk
Subject: group by month??
Hello cf-talk,
I have a list of events I want to show on a web page. Each event is
listed as month, days and name of event.
Needs to look like this on the webpage:
APRIL 22-26 Ricky and his stupid band
28-30 Carla and her bad voice
MAY 2-4 Zippy and the ZipRockets
10-12 Dummy and the Dummets
I'm trying to make a group by month CFOUTPUT work, but with no luck.
Since the GROUP BY looks at the complete date. No real grouping.
Can I group by just the month, or do I need to start at the input side
in the database. I was thinking of setting up the access database to
accept just a month, but it can't. I also need it to be a real date so
I can sort (not a text field)
Am I approaching this from the right angle?? Missing an obviously
better way to do this??
Best regards,
Jeff Fongemie mailto:[EMAIL PROTECTED]
------------------------
Internet Guns For Hire
(603) 356-0768
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
