http://en.wikipedia.org/wiki/Deadlock
On Thu, Aug 27, 2009 at 8:46 AM, Chad Gray <cg...@careyweb.com> wrote: > > I occasionally see this error in an application I wrote. > > Transaction (Process ID 54) was deadlocked on lock | communication buffer > resources with another process and has been chosen as the deadlock victim. > Rerun the transaction. > > The code that is causing this is below. > > <cfloop list="#variables.basicColorList#" index="i"> > <cfquery datasource="#application.dsn#" name="deleteColor"> > DELETE FROM #variables.table# > WHERE #variables.IDField# = #variables.ID# AND ColorName = > '#variables.i#' > </cfquery> > </cfloop> > > Pretty simple query... How do I keep this SQL from deadlocking? > > What is a deadlock? Two users hitting the code at the same time and > database cant handle all the requests? > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325769 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4