Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'size'.
|
|
The error occurred in E:/websites/GeigersEcommerce/functions/category.cfc: line 574
Called from E:/websites/GeigersEcommerce/includes/views/departments.cfm: line 44
Called from E:/websites/GeigersEcommerce/includes/views/departments.cfm: line 1
Called from E:/websites/GeigersEcommerce/includes/views/departments.cfm: line 1
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 282
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 1
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 1
Called from E:/websites/GeigersEcommerce/category.cfm: line 80
Called from E:/websites/GeigersEcommerce/functions/category.cfc: line 574
Called from E:/websites/GeigersEcommerce/includes/views/departments.cfm: line 44
Called from E:/websites/GeigersEcommerce/includes/views/departments.cfm: line 1
Called from E:/websites/GeigersEcommerce/includes/views/departments.cfm: line 1
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 282
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 1
Called from E:/websites/GeigersEcommerce/includes/sidenav.cfm: line 1
Called from E:/websites/GeigersEcommerce/category.cfm: line 80
|
572 : <!--- ***** START - LOOP THROUGH ACTIVE URL VARS AND PROCESS THEM FOR DB **** --->
573 : <Cfif isDefined("application.filterList") and ListLen(application.filterList) gt 0>
574 : <cfloop list="#application.filterList#" index="listItem">
575 : <cfif len(url[listItem]) and listItem neq "Keyword">
576 : <cfif listItem eq "Team">
|
|
SQLSTATE |
42S22 |
DATASOURCE |
celerantSQL |
VENDORERRORCODE |
207 |
SQL |
SELECT distinct dept, count(*) as itemCount FROM web_all_products_new WHERE dept<>'EMPTY'
and upper(size)='L,5.5,6,8S,13,11,2,XLS'
GROUP BY dept
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.219.214.127 |
Referrer |
https://shopgeigers.com/women/browse/size/l,5_5,6,8s,13,11,2,xls |
Date/Time |
20-Dec-24 11:09 PM |
|