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)='250-to-300'
and upper(Pricelist) like '%250 TO 300,%'
GROUP BY dept |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
3.138.170.67 |
Referrer |
https://skicountrysports.com/ski-helmets/browse/price/250-to-300/orderby/155/size/4l |
Date/Time |
04-Dec-24 09:56 PM |
|