My mySQL db does the same thing, although on the test I ran, I was able to
use an empty string as the field I tested allows 'null' values. Just for
laughs I tried ''LT 1'' and that worked, too.
-----------------------------------------
Matt Robertson [EMAIL PROTECTED]
MSB Designs, Inc. http://mysecretbase.com
-----------------------------------------
----- Original Message -----
From: "Chad Gray" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, September 04, 2001 10:09 AM
Subject: MySQL and Null Dates
First im wondering if this is a valid CF statement with a MySQL datefield
record?
<CFIF CLOCKOUT IS null> do this </CFIF>
Does CF know what null is? Because the only way i can get CF to understand
that the datefield is Null is to use:
<CFIF CLOCKOUT IS '0000-00-00 00:00:00'>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
