Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
|
|
The error occurred in D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm: line 48
Called from D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 201
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 188
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 186
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm: line 1096
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 303
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 297
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/add_options/simet/simet_urun_list.cfm: line 48
Called from D:/WORKCUBE_DOSYA/GERCEK/add_options/simet/simet_urun_list.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 201
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 188
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 186
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/display/dynamic_page.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm: line 1096
Called from D:/WORKCUBE_DOSYA/GERCEK/objects2/fbx_Switch.cfm: line 1
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 303
Called from D:/WORKCUBE_DOSYA/GERCEK/fbx_fusebox30_CF50.cfm: line 297
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
|
46 : IS_PUBLIC = 1
47 : <cfif isdefined('attributes.brand_id') and len(attributes.brand_id) and attributes.brand_id neq 0>
48 : AND PRODUCT_CATID IN ( #Valuelist(marka_kategori.product_cat_id)# )
49 : </cfif>
50 : AND HIERARCHY NOT IN(select HIERARCHY from PRODUCT_CAT where HIERARCHY like '%ZXC%')
|
|
SQLSTATE |
HY000 |
DATASOURCE |
workcube_simet_product |
VENDORERRORCODE |
102 |
SQL |
SELECT
PRODUCT_CAT,
PRODUCT_CATID,
HIERARCHY
FROM
PRODUCT_CAT
WHERE
IS_PUBLIC = 1
AND PRODUCT_CATID IN ( )
AND HIERARCHY NOT IN(select HIERARCHY from PRODUCT_CAT where HIERARCHY like '%ZXC%')
ORDER BY
HIERARCHY,
PRODUCT_CAT
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.144.77.71 |
Referrer |
http://www.simet.com.tr/index.cfm?fuseaction=objects2.view_product_list&brand_id=21 |
Date/Time |
26-Apr-24 02:55 PM |
|