Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Pricelist'.
|
|
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)='100-to-150'
and upper(Pricelist) like '%,%'
GROUP BY dept
|
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.136.236.17 |
Referrer |
https://shopgeigers.com/women/browse/price/100-to-150/size/8,9,20s,5,6s,12 |
Date/Time |
04-Nov-24 08:20 PM |
|