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'>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.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
