Error Occurred While Processing Request
The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.
The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request
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(Pricelist) like '%26,%'
GROUP BY dept
at cfcategory2ecfc1744178712$funcGETDEPARTMENTFILTER.runFunction(C:/websites/Skicountry/functions/category.cfc:576) at cfdepartments2ecfm888053368._factor15(C:/websites/Skicountry/includes/views/departments.cfm:45) at cfdepartments2ecfm888053368._factor16(C:/websites/Skicountry/includes/views/departments.cfm:1) at cfdepartments2ecfm888053368.runPage(C:/websites/Skicountry/includes/views/departments.cfm:1) at cfsidenav2ecfm995677278._factor13(C:/websites/Skicountry/includes/sidenav.cfm:297) at cfsidenav2ecfm995677278._factor15(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfsidenav2ecfm995677278.runPage(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfcategory2ecfm1749867363.runPage(C:/websites/Skicountry/category.cfm:139) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193) at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126) at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275) at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035) at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632) at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at cfcategory2ecfc1744178712$funcGETDEPARTMENTFILTER.runFunction(C:/websites/Skicountry/functions/category.cfc:576) at cfdepartments2ecfm888053368._factor15(C:/websites/Skicountry/includes/views/departments.cfm:45) at cfdepartments2ecfm888053368._factor16(C:/websites/Skicountry/includes/views/departments.cfm:1) at cfdepartments2ecfm888053368.runPage(C:/websites/Skicountry/includes/views/departments.cfm:1) at cfsidenav2ecfm995677278._factor13(C:/websites/Skicountry/includes/sidenav.cfm:297) at cfsidenav2ecfm995677278._factor15(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfsidenav2ecfm995677278.runPage(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfcategory2ecfm1749867363.runPage(C:/websites/Skicountry/category.cfm:139)
java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Pricelist'.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1085)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1613)
at coldfusion.sql.Executive.executeQuery(Executive.java:1355)
at coldfusion.sql.Executive.executeQuery(Executive.java:1285)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1167)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:868)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
at cfcategory2ecfc1744178712$funcGETDEPARTMENTFILTER.runFunction(C:\websites\Skicountry\functions\category.cfc:576)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:623)
at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:516)
at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:463)
at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:438)
at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:310)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:975)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:696)
at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:503)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4264)
at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:4227)
at cfdepartments2ecfm888053368._factor15(C:\websites\Skicountry\includes\views\departments.cfm:45)
at cfdepartments2ecfm888053368._factor16(C:\websites\Skicountry\includes\views\departments.cfm:1)
at cfdepartments2ecfm888053368.runPage(C:\websites\Skicountry\includes\views\departments.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211)
at cfsidenav2ecfm995677278._factor13(C:\websites\Skicountry\includes\sidenav.cfm:297)
at cfsidenav2ecfm995677278._factor15(C:\websites\Skicountry\includes\sidenav.cfm:1)
at cfsidenav2ecfm995677278.runPage(C:\websites\Skicountry\includes\sidenav.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5211)
at cfcategory2ecfm1749867363.runPage(C:\websites\Skicountry\category.cfm:139)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
at coldfusion.CfmServlet.service(CfmServlet.java:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:355)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:450)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:928)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1794)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)
