Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'catalog_id'.
|
|
The error occurred in D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/store/browse.cfm: line 31
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/store/store.cfm: line 764
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/store/store.cfm: line 1
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/index.cfm: line 44
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/layout_2.cfm: line 16
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/global.cfm: line 605
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/Application.cfm: line 190
Called from |SQLServer|6.0.0.1282|: line 1085
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 1059
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 526
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 2703
Called from |SQLServer|6.0.0.1282|: line 525
Called from |SQLServer|6.0.0.1282|: line 1085
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 1059
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 526
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 2703
Called from |SQLServer|6.0.0.1282|: line 525
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/store/browse.cfm: line 31
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/store/store.cfm: line 764
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/store/store.cfm: line 1
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/index.cfm: line 44
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/layout_2.cfm: line 16
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/global.cfm: line 605
Called from D:/virtualwww/site_effects/clients/mis_splash/CXMLConnect/gateway/RE/V2/Application.cfm: line 190
|
29 : <CFIF #IsDefined("session.catalog_id")# AND #session.catalog_id# IS NOT ''>
30 : AND catalog_id = <CFQUERYPARAM VALUE="#session.catalog_id#">
31 : <CFELSE>
32 : AND catalog_id = 0
33 : </CFIF>
|
|
SQLSTATE |
42S22 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
RE |
VENDORERRORCODE |
207 |
SQL |
SELECT * FROM category_Table
WHERE 0=0
AND Cat_Parent = (param 1)
AND Category_Status = 1
AND item_count > 0
AND catalog_id = 0
ORDER BY category_order, category_name |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.118.1.158 |
Referrer |
|
Date/Time |
26-Apr-24 06:36 PM |
|