Why? Value is showing as "false" in management studio after running.
<cfquery
name="qry_cart_hide_adjustments"
datasource="#request.dataSource#">
update
#request.sqlobjectprefix#tblCartAdjustments
set displayed = <cfqueryparam
value="1" cfsqltype="CF_SQL_BIT">
where 1 = 1
<cfif len(arguments.app_user_id)>
and tblpeoplefk = <cfqueryparam
value="#val(arguments.app_user_id)#" cfsqltype="cf_sql_integer">
</cfif>
<cfif len(arguments.cf_user_id)>
and cfuserid = <cfqueryparam
value="#trim(arguments.cf_user_id)#" cfsqltype="cf_sql_varchar">
</cfif>
</cfquery>
update rhkProd_tblCartAdjustments
set displayed = ?
where 1 = 1
and tblpeoplefk = ?
and cfuserid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_BIT) = YES
Parameter #2(cf_sql_integer) = 0
Parameter #3(cf_sql_varchar) = 1506_18149772
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3320
Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
