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
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
>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
>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
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
5 matches
Mail list logo