I have a query on a page that gets called from a cfdiv. Basically the div refreshes and runs the query every minute.
I am receiving the below error periodically. Does anyone know how to prevent this in ColdFusion?
Diagnostics: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 74) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
The error occurred on line 55