i believe i had a similar problem check to see if its wrapped in "cftransaction" tags, that will not allow more than one person at a time to use that query at a time -Eli- -----Original Message----- From: Adrian Cesana <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Wednesday, July 05, 2000 2:47 PM Subject: RE: (Serialization failure) deadlocked >No but this whole template is wrapped inside of a Custom tag >(http://www.icesinc.com/nate/taggallery/CF_FileWriteText/CF_FileWriteText.h t >ml)that writes output to a file. Im starting to think this may have >something to do with it. The template is actually not used by the outside >world, its really only run once a day to generate a file. My first >impressions were that it is a DB locking situation, maybe the err message is >misleading. This does not consistently occur... > > > >> -----Original Message----- >> From: Jennifer [mailto:[EMAIL PROTECTED]] >> >> >> > >> >ODBC Error Code = 40001 (Serialization failure) [Microsoft][ODBC >> SQL Server >> >Driver][SQL Server]Your transaction (process ID #47) was deadlocked with >> >another process and has been chosen as the deadlock victim. > > > >> Are there application scope variables or is <cflock> used? > >--------------------------------------------------------------------------- --- >Archives: http://www.mail-archive.com/[email protected]/ >To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body. > ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
