Dave Watts wrote: > I don't think this is correct. If you explicitly pass NULL, that's what > you're going to get regardless of any default value for the column.
I concur with Dave, not hard to do. You would have to have you SQL dynamically not try and set the given field for the default to take affect, if you send a NULL a NULL is going to be what you get, or an error if NULL's are not allowed. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:312465 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
