I figured it out.. suffice it to say I'm stoopid... and it helps if I reference the right template.. ----- Original Message ----- From: "Paul Ihrig" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Thursday, February 22, 2007 3:34 PM Subject: Re: Here's a weird one
> can you move the varibles ssid into just a regular cfpram & then try to > dump it? > > On 2/22/07, Scott Stewart <[EMAIL PROTECTED]> wrote: >> 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. >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 & Flex 2. Free Trial http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
