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 '-00-00 00:00:00'

Re: MySQL and Null Dates

ACK! i figured out part of my problem. I used DBTools to convert an Access DB to MySQL. Well the import turned Access's Nulls to -00-00 00:00:00. I will have to go in and replace all -00-00 00:00:00 with a MySQL Null. Im still wondering what CF's null is? is it just plain old CFIF

RE: MySQL and Null Dates

Does CF know what null is? No, it doesn't. When a recordset contains NULLs, CF converts them to empty strings. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ phone: (202) 797-5496 fax: (202) 797-5444 ~~ Get the mailserver that

Re: MySQL and Null Dates

://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