Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Transaction (Process ID 98) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
|
The error occurred in D:/Websites/PSQonline.org/CFC/Model/Cart.cfc: line 161
Called from D:/Websites/PSQonline.org/Cart.cfm: line 57
Called from D:/Websites/PSQonline.org/CFC/Model/Cart.cfc: line 161
Called from D:/Websites/PSQonline.org/Cart.cfm: line 57
|
159 : </cfif>
160 : WHERE txtBasketID = <cfqueryparam cfsqltype="cf_sql_varchar" value="#Arguments.BasketID#">
161 : AND IDProduct IN (SELECT IDProduct FROM Products WHERE txtProductName IN (#ListQualify(variables.listIDProduct_Ext_Price, "'")#))
162 : </cfquery>
163 :
|
|
SQLSTATE |
40001 |
DATASOURCE |
PSQOnline |
VENDORERRORCODE |
1205 |
SQL |
UPDATE TempBasket
SET mPrice = (SELECT intPrice FROM Books WHERE Books.IDBook = TempBasket.txtDetails)
WHERE txtBasketID = (param 1)
AND IDProduct IN (SELECT IDProduct FROM Products WHERE txtProductName IN ('Book PDF','Book Print'))
|
|
Resources:
|
Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
Remote Address |
3.231.102.4 |
Referrer |
|
Date/Time |
04-Mar-21 01:51 AM |
|