is the field configured to accept null values? are you actually
inserting a NULL or are you just not inserting anything. if you're
not inserting anything, it'll default to the default value (which
seems to be 1/1/1900).
INSERT INTO tablename (col1, myDateCol) VALUES ('foo', NULL)
or in an update:
UPDATE
tablename
SET
myDateCol = NULL
WHERE
....
On Nov 7, 2007 10:38 AM, Jason Presley <[EMAIL PROTECTED]> wrote:
> How to i insert a null field into a ms sql 2005 date/time field? All I get
> is it inserting the value 01/1/1900.
>
> Thanks!
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:292865
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
