[thelist] CF & MySQL: Date/Time operations

[Chris Hayes]

This is messy.

I'm not around a CF server ATM but yes the QoQ might well make a difference 
as MySQL is no longer in use... it's purely CF

I'd still contain the ODBCdate in single quotes

'#CreateODBCDate(Now())#'

???



----- Original Message ----- 
From: "Minh Lee Goon" <evolt at goonies.info>
To: <thelist at lists.evolt.org>
Sent: Tuesday, July 18, 2006 10:48 PM
Subject: Re: [thelist] CF & MySQL: Date/Time operations


> I've tried that, and it doesn't work. Would it matter that it's a query
> of another query? My error message is:
>
> Query Of Queries syntax error.
> Encountered "(" at line 0, column 0.
>
>
> Hassan Schroeder wrote:
>> If your CF function is just getting the current date, why not use
>> the native MySQL function and skip that CF call altogether?
>
>
> -- 
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.10.1/390 - Release Date: 17/07/2006
>
>