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:283659 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
