Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Pricelist'.
|
|
The error occurred in C:/websites/Skicountry/functions/category.cfc: line 576
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 45
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 1
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 1
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 297
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1
Called from C:/websites/Skicountry/category.cfm: line 139
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 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 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
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 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 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from C:/websites/Skicountry/functions/category.cfc: line 576
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 45
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 1
Called from C:/websites/Skicountry/includes/views/departments.cfm: line 1
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 297
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1
Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1
Called from C:/websites/Skicountry/category.cfm: line 139
|
574 : <!--- ***** START - LOOP THROUGH ACTIVE URL VARS AND PROCESS THEM FOR DB **** --->
575 : <Cfif isDefined("application.filterList") and ListLen(application.filterList) gt 0>
576 : <cfloop list="#application.filterList#" index="listItem">
577 : <cfif len(url[listItem]) and listItem neq "Keyword">
578 : <cfif listItem eq "Team">
|
|
SQLSTATE |
42S22 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
celerantSQL |
VENDORERRORCODE |
207 |
SQL |
SELECT distinct dept, count(*) as itemCount FROM web_all_products WHERE dept<>'EMPTY'
and upper(pricerange)='25-to-50'
and upper(Pricelist) like '%25 TO 50,%'
GROUP BY dept |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.191.239.181 |
Referrer |
https://skicountrysports.com/snowboard-socks/browse/price/25-to-50/orderby/shop=snowboards/size/s-m |
Date/Time |
16-Nov-24 08:59 AM |
|