"Date" is a reserved word
----- Original Message -----
From: "Jeff Fongemie" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, May 02, 2001 10:25 AM
Subject: help, More Group by Month
> Hello All ,
>
> still trying to get this thing to work.
>
> Why does this error? My field names are ID, date and name.
>
>
>
> <cfquery name="event" datasource="#application.dsn#" dbtype="ODBC">
>
>
> SELECT date, name
> FROM entertain
> GROUP BY DATEPART(m,date)
> ORDER BY month
> </cfquery>
>
>
>
>
> 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists