Error Executing Database Query.
|
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Suspend = no AND Product_ID IN () AND product_ID <> 1274'.
|
|
The error occurred in D:/inetpub/wwwroot/iEditCarts-Access/Whimsicality/details.cfm: line 237
Called from D:/inetpub/wwwroot/iEditCarts-Access/Whimsicality/details.cfm: line 229
Called from D:/inetpub/wwwroot/iEditCarts-Access/Whimsicality/details.cfm: line 1
Called from D:/inetpub/wwwroot/iEditCarts-Access/Whimsicality/iedit_redirect.cfm: line 13
Called from D:/inetpub/wwwroot/iEditCarts-Access/Whimsicality/details.cfm: line 237
Called from D:/inetpub/wwwroot/iEditCarts-Access/Whimsicality/details.cfm: line 229
Called from D:/inetpub/wwwroot/iEditCarts-Access/Whimsicality/details.cfm: line 1
Called from D:/inetpub/wwwroot/iEditCarts-Access/Whimsicality/iedit_redirect.cfm: line 13
|
235 : AND Product_ID IN (#product.Crosssell#)
236 : </cfif>
237 : AND product_ID <> #product_ID#
238 : ORDER BY preference
239 : </CFQUERY>
|
|
SQLSTATE |
42000 |
DATASOURCE |
WhimsicalityCart |
VENDORERRORCODE |
-3100 |
SQL |
SELECT * FROM products WHERE Suspend = no
AND Product_ID IN ()
AND product_ID <> 1274
ORDER BY preference
|
|
Resources:
|
Browser |
claudebot |
Remote Address |
54.224.52.210 |
Referrer |
|
Date/Time |
29-Mar-24 10:13 PM |
|