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:270522 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
