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(pricerange)='200-to-250'
and upper(size)='MD,16S,9,12S,4S,18,XXL,XS,5'
GROUP BY dept
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.116.28.79 |
Referrer |
https://shopgeigers.com/women/browse/size/s,lg,16,ms,m/price/200-to-250 |
Date/Time |
22-Dec-24 09:52 PM |
|