Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near '='.
|
|
The error occurred in D:/home/offwhiterecords.com/wwwroot/store/item.cfm: line 44
Called from D:/home/offwhiterecords.com/wwwroot/store/catalogue/entombed-wolverine-blues-lp.cfm: line 2
Called from |SQLServer|6.0.0.1282|: line 1103
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from |SQLServer|6.0.0.1282|: line 1103
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from D:/home/offwhiterecords.com/wwwroot/store/item.cfm: line 44
Called from D:/home/offwhiterecords.com/wwwroot/store/catalogue/entombed-wolverine-blues-lp.cfm: line 2
|
42 : AND CAIM.name LIKE '%pack%.jpg'), '//strypt.com/no_image/no_image_510.jpg') AS lightboximg
43 : FROM Catalogue_OWR CATA
44 : WHERE CATA_ID = #qCATA.CATA_ID#
45 : </cfquery>
46 : <!---<cfif imageExists("//images.limecherry.com/large/#qCATA.barcode_bigint#.jpg")>
|
|
SQLSTATE |
HY000 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
webdb |
VENDORERRORCODE |
102 |
SQL |
SELECT COALESCE((SELECT TOP 1 CAIM.path
FROM Catalogue_Images_OWR CAIM
WHERE CAIM.CATA_CATA_ID = CATA.CATA_ID
AND CAIM.name LIKE '%510.jpg'),
(SELECT TOP 1 CAIM.path
FROM Catalogue_Images_OWR CAIM
WHERE CAIM.CATA_CATA_ID = CATA.CATA_ID
AND CAIM.name LIKE '%pack%.jpg'), '//strypt.com/no_image/no_image_510.jpg') AS lightboximg
FROM Catalogue_OWR CATA
WHERE CATA_ID = |
|
Resources:
|
Browser |
claudebot |
Remote Address |
44.223.39.199 |
Referrer |
|
Date/Time |
29-Mar-24 11:02 AM |
|