Without testing this, I would say you need to pass a "0" or "1" to this column. I doubt the database knows enough to convert "True" to a boolean.
Therefore, it assumes that you are setting MyColumn equal to the value from the "True" column. M!ke -----Original Message----- From: Robert Rawlins - Think Blue [mailto:[EMAIL PROTECTED] Sent: Friday, July 13, 2007 9: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, ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283658 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
