Removed evaluate() function and replaced it with simple structure syntax. Rather than fetching a newly inserted record (a good way to have a lock problem) I used the scope_identity() function to grab the ID
Reduced timeout to 10 seconds.Ĭhanged how you got your Primary Key field. Names are unique across the entire application. Please give this a try, several changes as follows.Ĭhanged CFLOCK to scope="session" rather than a named lock. Thanks INSERT INTO AffStd_TAB ( AffiliateCode, ProgramTitle, TransactionDescription, ProgramType, TargetAgeRange, Tuuid ) VALUES ( '#wTempAffiliateCode#', '#form.fProgramTitle#', '#form.fTransactionDescription#', '#form.fProgramType#', '#form.fTargetAgeRange#', '#wUUID#' ) SELECT PK FROM AffStd_TAB WHERE Tuuid = '#wUUID#' INSERT INTO AffStd_TAB_Detail ( MasterRecPK, AFieldName, AFieldValue ) VALUES ( '#wNewPK#', '#Evaluate("form.fAFieldName#i#")#', '#Evaluate("form.fAFieldValue#i#")#' ) Greetings, An error has occured while attenpting to insert an Affiliate master record and corresponding detail records into tables: AffStd_TAB and AffStd_TAB_Detail A dump of the cfcatch variable is below.
#SQL SERVER DEADLOCK ERROR CODE CODE#
Should it be troubleshot at the coldfusion code level orĪt the SQL query level? Would wrapping the cftransaction tag Question: How can I keep from getting the deadlock error? all users logged in with username: user1 and password: pwd1), then I get a deadlock error. However, if I run it with several users logged in at once using the same username and password (e.g. If I run it with 1 user logged in, as username: user1 and password: pwd1 then it behaves fine, as expected with no error. I have the following script (in the code window below) which gives me a deadlock error when
0 kommentar(er)
