Hey, that worked -- wrote an empty field (ie does not show <NULL>) but I'm happy.
THANKS. ----- Original Message ----- From: "Mike Townend" <[EMAIL PROTECTED]> To: "SQL" <[EMAIL PROTECTED]> Sent: Tuesday, October 22, 2002 8:35 AM Subject: RE: Passing NULL to SQL Server > Depending on your DB setting the field to null might work... > > i.e. > > Update foo > Set bar = null > > Failing that have a look at using <CFQUERYPARAM> in your queries.. That > tag allows you to send null values to the query.. > > > HTH > > > > -----Original Message----- > From: Susan H. Allen [mailto:susan_hamilton_allen@;hotmail.com] > Sent: Tuesday, October 22, 2002 13:35 > To: SQL > Subject: Passing NULL to SQL Server > > > I am having a hard time passing <NULL> values to SQL Server -- the DBA > has enabled NULLs for integer and bit fields (yeah, a bit field should > be 1 or 0, not NULL, but not my call). I am writing standardized > queries to insert and update these tables, and I need to insert a <NULL> > in these fields; I know this is probably really basic, but it's driving > me nuts. If an insert query does not explicitly write to these fields, > a <NULL> is inserted, but I want to write to all fields so that these > queries are all standardized throughout the application. (And, of > course, if one of these fields in an update holds data but now must be > cleared, I need to write a <NULL>). Any tips would be much appreciated. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=6 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/sql This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.
