.... And the single quotes probably came from an ODBC data source. My guess would be
the error is found now due a switch in backend DB's more so than the OS switch. Not
sure if there's a robust way to translate an ODBC data into a CF Date structure to
guarantee correctness across all sorts of different situations.
Somebody else hop in and fill that one in :)
Justin Buist
On Wed, Mar 28, 2001 at 09:23:33AM +0100, Frank Hilliard wrote:
>
> Just looking at the error message, it looks as if you have the date in single
>quotes. Try taking them off.
>
> Frank Hilliard
>
> "Brown, Brian" wrote:
>
> An error occurred while evaluating the expression:
> > DateDiff("n", Now(), client.expires) GT "0"
> > Error near line 15, column 44.
> > Parameter 3 of function DateDiff which is now "'2001-03-27 12:34:18'"
> > must be a date/time value
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-linux%40houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_linux or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
