How are you trying? Should be as simple as SET COLNAME = NULL or using a cfqueryparam tag with its null attribute set to true.
On Nov 7, 2007 12:30 PM, Jason Presley <[EMAIL PROTECTED]> wrote: > I have a table that contains two fields to indicate when a production run > is scheduled. It indicates that start and end dates of the run. When a run > is not scheduled I need to allow the user to simply remove the date and set > the value of the field back to NULL. Every time I try this it sets the > value to 01/1/1900. How do I get the value to be NULL? (Allow NULL is set > for the field in the table). > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292873 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
