In a template I'm working on (it's CF5.0 that's why we're locking vars.)
I'm locking the session var Session.ID, then setting Variables.ssId with the
value
<cflock scope="Session" type="EXCLUSIVE" timeout="10">
<cfset Variables.sOrgId=Session.Org_Id>
<cfset Variables.sPatientId=Session.Patient_Id>
<cfset Variables.sUserId=Session.User_Id>
<cfset Variables.ssId=Session.Id>
</cflock>
in the "delete" query for allergies i'm setting removed_by with the value
<cfquery datasource="#Variables.EMRDataSource#" name="AllergyDelete">
Update Allergy
Set Hidden=<cfqueryparam cfsqltype="CF_SQL_BIT" value="1">,
Removed_By=<cfqueryparam cfsqltype="CF_SQL_BIGINT" value="#Variables.ssId#">
Where Allergy_Id=<cfqueryparam cfsqltype="CF_SQL_BIGINT"
value="#Form.Allergy_Id#">
</cfquery>
when the query runs, the value for removed_by isn't set. The query doesn't
throw an error. and all other values are set.... any ideas.
I can do a cfdump and both variables have values.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270515
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
