That should do it. Just wanted to mention that you could also try
GROUP BY DATEPART(m,myDateField)
-David
On Tuesday, May 01, 2001 5:05 PM, Bob Silverberg [SMTP:[EMAIL PROTECTED]]
wrote:
> 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
