Thanks, everyone. Once again, this is a great community. ;-)
Noam's elegant iff solution isn't working for me just yet, but the more
straightforward IF statement works fine in the interim.
Take care, and Happy Holidays to all.
Carla Shafer
<http://www.munex.net>
At 06:34 PM 12/14/00 +0100, BOROVOY Noam wrote:
>CF defaults an empty field to an empty string not a NULL,
>Use iif in the insert SQL to put in NULL if the field is not a date using
>isDate() such as:
>#iif(isDate(attributes.datefield), DE('###attributes.datefield ###'),
>DE('NULL'))#
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
