Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near 'BY'.
|
|
The error occurred in D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 152
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 68
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/dynamic.cfm: line 5
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/main.cfm: line 123
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 28
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 70
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 349
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 321
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/index.cfm: line 33
Called from D:/WORKCUBE_DOSYA/GERCEK/Application.cfc: line 40
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 152
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 68
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/product_list.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/dynamics/dynamic.cfm: line 5
Called from D:/WORKCUBE_DOSYA/GERCEK/documents/templates/xentino/main.cfm: line 123
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 28
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 70
Called from D:/WORKCUBE_DOSYA/GERCEK/real_dsp_sablon.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 349
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 321
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/index.cfm: line 33
Called from D:/WORKCUBE_DOSYA/GERCEK/Application.cfc: line 40
|
150 : PR.RECORD_DATE <cfif attributes.order_element gt 10>DESC<cfelse>ASC</cfif>
151 : </cfif>
152 : <cfelse>
153 : <!--- PR.PRODUCT_CATID--->
154 : PR.RECORD_DATE DESC
|
|
SQLSTATE |
HY000 |
DATASOURCE |
workcube_simet_4 |
VENDORERRORCODE |
102 |
SQL |
SELECT
PR.*,
PRODUCT_CAT,
CONVERT(INT, PI.PROPERTY3) AS PROPERTY3,
PC.PRODUCT_COMMENT_POINT
FROM
PRODUCT PR
JOIN
PRODUCT_CAT
ON PRODUCT_CAT.PRODUCT_CATID = PR.PRODUCT_CATID
LEFT JOIN
PRODUCT_INFO_PLUS PI
ON PI.PRODUCT_ID = PR.PRODUCT_ID
LEFT JOIN
PRODUCT_COMMENT PC
ON PC.PRODUCT_ID = PR.PRODUCT_ID
WHERE
PR.PRODUCT_STATUS = 1 AND
PR.IS_INTERNET = 1 AND
PR.PRODUCT_STATUS = 1 AND
PR.IS_INVENTORY = 1 AND
PR.IS_SALES = 1 AND
PR.BRAND_ID = 30
AND
(
PRODUCT_CAT.PRODUCT_CATID = (param 1)
OR
PRODUCT_CAT.HIERARCHY LIKE (param 2)
)
AND HIERARCHY NOT IN(select HIERARCHY from PRODUCT_CAT where HIERARCHY like '%ZXC%')
ORDER BY
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
108.162.216.62 |
Referrer |
|
Date/Time |
26-Apr-24 03:26 PM |
|