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)='6,2S,20S'
and upper(sizelist) like '%6,2S,20S,%'
GROUP BY dept
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
13.58.161.216 |
Referrer |
https://shopgeigers.com/women-the-snowsport-apparel-shop/browse/size/6,2s,20s/price/450-to-500 |
Date/Time |
05-Nov-24 06:25 AM |
|