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

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 documenta

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 >wrote: > >> Maybe I am mis-understanding the functions. Is DatePart a function of MS Access? Is that why it wont work? If I us

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 >wrote: > >>I may be misunderstanding you but the DatePart is a ColdFusion function (I >>believe)?. I copied the code from anoth

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 wrote: > > I am working on a simple query using DatePart. > I am running CF9 on a Mac with MySQL. > > The code looks like this: > > SE