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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283657 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
