Use "= NULL" in your SQL statement.
UPDATE thetable
SET this = 'that',
thedate = NULL
WHERE something = #somethingelse#
Jim
----- Original Message -----
From: "Mario Martinez R." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Saturday, April 13, 2002 1:04 PM
Subject: Re: null DateTime value
> Thanks Dave.
> I did that before.
> but when I pass an empty string to sql server to
> update a DateTime cell , what I see in the table is
> this wierd date: 1/1/1900
> Any ideas??
> Thank for replying
> Mario
______________________________________________________________________
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
