Re: help, More Group by Month

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

RE: help, More Group by Month

This won't work because you are including a column (name) in your select list that is not included in an aggregate function, which you need to do if you are grouping -- Andrew Ewings Project Manager Thoughtbubble Ltd

RE: help, More Group by Month

Jeff; I think if you were to change the name of your column from date to some_date or something other than Date, you will take care of a lot of your problem. Larry Juncker Senior Cold Fusion Developer Heartland Communications Group, Inc. -Original Message- From: Jeff Fongemie

RE: help, More Group by Month

Subject: RE: help, More Group by Month This won't work because you are including a column (name) in your select list that is not included in an aggregate function, which you need to do if you are grouping -- Andrew Ewings Project Manager