Thanks guys, You're both spot on! I was confused as when I view the table in SSMS it displays the column values as True/False and not 1/0 but this must just be a presentation thing.
Thanks, Rob -----Original Message----- From: Scott Stewart [mailto:[EMAIL PROTECTED] Sent: 13 July 2007 15:35 To: CF-Talk Subject: RE: Updating BIT Column Hey Rob "true" and "false" are access centric, you'll need to use 1 or 0 -- Scott Stewart ColdFusion Developer SSTWebworks 7241 Jillspring Ct. Springfield, Va. 22152 (703) 220-2835 http://www.sstwebworks.com http://www.linkedin.com/in/sstwebworks -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 10:18 AM To: CF-Talk Subject: Updating BIT Column Hello Guys, I'm trying to run a small update query but i'm having a few problems getting it working correctly, here is the query syntax: UPDATE MyTable SET MyColumn = <cfqueryparam value="True" cfsqltype="cf_sql_bit" /> WHERE AnotherColumn = <cfqueryparam value="#SESSION.User.getProfile().getSomthingID()#" cfsqltype="cf_sql_integer" /> However when i run this i get the following error: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'True'. What's wrong with my syntax? Thanks guys, Rob ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283661 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
