Thank you Jim I gonna try this way. Thanks all regards Mario --- Jim McAtee <[EMAIL PROTECTED]> escribió: > 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 >
______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists