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 0000-00-00
00:00:00.
I will have to go in and replace all 0000-00-00 00:00:00 with a MySQL Null.
Im still wondering what CF's null is? is it just plain old <CFIF CLOCKOUT
IS ""> ????
At 01:09 PM 9/4/2001 -0400, you wrote:
>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'>
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
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
