Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Size'.
|
|
The error occurred in C:/websites/Piragis/functions/category.cfc: line 701
Called from C:/websites/Piragis/includes/views/departments.cfm: line 40
Called from C:/websites/Piragis/includes/views/departments.cfm: line 1
Called from C:/websites/Piragis/includes/views/departments.cfm: line 1
Called from C:/websites/Piragis/includes/sidenav.cfm: line 194
Called from C:/websites/Piragis/includes/sidenav.cfm: line 1
Called from C:/websites/Piragis/includes/sidenav.cfm: line 1
Called from C:/websites/Piragis/category.cfm: line 227
Called from C:/websites/Piragis/category.cfm: line 224
Called from C:/websites/Piragis/category.cfm: line 1
Called from C:/websites/Piragis/category.cfm: line 1
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/Piragis/functions/category.cfc: line 701
Called from C:/websites/Piragis/includes/views/departments.cfm: line 40
Called from C:/websites/Piragis/includes/views/departments.cfm: line 1
Called from C:/websites/Piragis/includes/views/departments.cfm: line 1
Called from C:/websites/Piragis/includes/sidenav.cfm: line 194
Called from C:/websites/Piragis/includes/sidenav.cfm: line 1
Called from C:/websites/Piragis/includes/sidenav.cfm: line 1
Called from C:/websites/Piragis/category.cfm: line 227
Called from C:/websites/Piragis/category.cfm: line 224
Called from C:/websites/Piragis/category.cfm: line 1
Called from C:/websites/Piragis/category.cfm: line 1
|
699 : <!--- ***** START - LOOP THROUGH ACTIVE URL VARS AND PROCESS THEM FOR DB **** --->
700 : <Cfif isDefined("application.filterList") and ListLen(application.filterList) gt 0>
701 : <cfloop list="#application.filterList#" index="listItem">
702 : <cfif len(url[listItem]) and listItem neq "Keyword">
703 : <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(Size)='4'
and upper(Sizelist) like '%4,%'
GROUP BY dept |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
172.69.7.33 |
Referrer |
https://boundarywaterscatalog.com/paddles-canoe/browse/size/4/orderby/name-a-to-z/price/300-to-350 |
Date/Time |
25-Dec-24 07:42 PM |
|