MEN

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 E:/websites/GeigersEcommerce/functions/category.cfc: line 590
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 300
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 84
Called from E:/websites/GeigersEcommerce/functions/category.cfc: line 590
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 300
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 84

588 : 		<!--- ***** START - LOOP THROUGH ACTIVE URL VARS AND PROCESS THEM FOR DB **** --->
589 : 		<Cfif isDefined("application.filterList") and ListLen(application.filterList) gt 0>
590 : 			<cfloop list="#application.filterList#" index="listItem">
591 : 				<cfif len(url[listItem])  and listItem neq "Keyword">
592 : 					<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(Pricelist) like '%,%' GROUP BY dept

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address	216.73.216.128
Referrer
Date/Time	29-Oct-25 01:26 AM

Stack Trace

at cfcategory2ecfc1240052244$funcGETDEPARTMENTFILTER.runFunction(E:/websites/GeigersEcommerce/functions/category.cfc:590) at cfdepartments2ecfm1610687894._factor23(E:/websites/GeigersEcommerce/includes/views/departments.cfm:44) at cfdepartments2ecfm1610687894._factor24(E:/websites/GeigersEcommerce/includes/views/departments.cfm:1) at cfdepartments2ecfm1610687894.runPage(E:/websites/GeigersEcommerce/includes/views/departments.cfm:1) at cfsidenav2ecfm527733393._factor14(E:/websites/GeigersEcommerce/includes/sidenav.cfm:300) at cfsidenav2ecfm527733393._factor15(E:/websites/GeigersEcommerce/includes/sidenav.cfm:1) at cfsidenav2ecfm527733393.runPage(E:/websites/GeigersEcommerce/includes/sidenav.cfm:1) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:84) at cfcategory2ecfc1240052244$funcGETDEPARTMENTFILTER.runFunction(E:/websites/GeigersEcommerce/functions/category.cfc:590) at cfdepartments2ecfm1610687894._factor23(E:/websites/GeigersEcommerce/includes/views/departments.cfm:44) at cfdepartments2ecfm1610687894._factor24(E:/websites/GeigersEcommerce/includes/views/departments.cfm:1) at cfdepartments2ecfm1610687894.runPage(E:/websites/GeigersEcommerce/includes/views/departments.cfm:1) at cfsidenav2ecfm527733393._factor14(E:/websites/GeigersEcommerce/includes/sidenav.cfm:300) at cfsidenav2ecfm527733393._factor15(E:/websites/GeigersEcommerce/includes/sidenav.cfm:1) at cfsidenav2ecfm527733393.runPage(E:/websites/GeigersEcommerce/includes/sidenav.cfm:1) at cfcategory2ecfm908738381.runPage(E:/websites/GeigersEcommerce/category.cfm:84)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'Pricelist'.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda3.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1485)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1235)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1165)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1187)
	at coldfusion.tagext.sql.QueryTag.setupCachedQuery(QueryTag.java:1121)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:808)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769)
	at cfcategory2ecfc1240052244$funcGETDEPARTMENTFILTER.runFunction(E:\websites\GeigersEcommerce\functions\category.cfc:590)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:383)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:334)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:231)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:646)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:435)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:405)
	at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2489)
	at cfdepartments2ecfm1610687894._factor23(E:\websites\GeigersEcommerce\includes\views\departments.cfm:44)
	at cfdepartments2ecfm1610687894._factor24(E:\websites\GeigersEcommerce\includes\views\departments.cfm:1)
	at cfdepartments2ecfm1610687894.runPage(E:\websites\GeigersEcommerce\includes\views\departments.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfsidenav2ecfm527733393._factor14(E:\websites\GeigersEcommerce\includes\sidenav.cfm:300)
	at cfsidenav2ecfm527733393._factor15(E:\websites\GeigersEcommerce\includes\sidenav.cfm:1)
	at cfsidenav2ecfm527733393.runPage(E:\websites\GeigersEcommerce\includes\sidenav.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:3011)
	at cfcategory2ecfm908738381.runPage(E:\websites\GeigersEcommerce\category.cfm:84)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:247)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:736)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:572)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:495)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:153)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:219)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:494)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:458)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:196)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Unknown Source)