Re: DatePart Function Missing

2010-02-01 Thread Daniel Baughman
I think you may be missing some pound symbols as I am not aware that MySql has a datepart function. Cheers, Dan On Feb 1, 2010, at 6:44 PM, Chad Veldhouse cveldho...@vaagency.com wrote: I am working on a simple query using DatePart. I am running CF9 on a Mac with MySQL. The code looks

Re: DatePart Function Missing

2010-02-01 Thread Chad Veldhouse
I think you may be missing some pound symbols as I am not aware that MySql has a datepart function. Cheers, Dan On Feb 1, 2010, at 6:44 PM, Chad Veldhouse cveldho...@vaagency.com wrote: I may be misunderstanding you but the DatePart is a ColdFusion function (I believe)?. I copied the code

Re: DatePart Function Missing

2010-02-01 Thread Chad Veldhouse
I think you may be missing some pound symbols as I am not aware that MySql has a datepart function. Cheers, Dan On Feb 1, 2010, at 6:44 PM, Chad Veldhouse cveldho...@vaagency.com wrote: Maybe I am mis-understanding the functions. Is DatePart a function of MS Access? Is that why it wont

Re: DatePart Function Missing

2010-02-01 Thread Matt Quackenbush
In the sample you posted, DatePart() is not surrounded by hashes (#). This means that you are calling the database's DatePart() function. Apparently MySQL does not have such a function, which is why you are receiving the error message. (I do not use MySQL, so you'd have to check their

RE: DatePart Function Missing

2010-02-01 Thread Will Swain
Subject: Re: DatePart Function Missing In the sample you posted, DatePart() is not surrounded by hashes (#). This means that you are calling the database's DatePart() function. Apparently MySQL does not have such a function, which is why you are receiving the error message. (I do not use MySQL