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 'SUBTYP_1'.
 
The error occurred in C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm: line 274
Called from C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm: line 264
Called from C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm: line 248
Called from C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm: line 1
Called from C:/home/aardvarkarmory.com/wwwroot/router.cfm: line 12
Called from C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm: line 274
Called from C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm: line 264
Called from C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm: line 248
Called from C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm: line 1
Called from C:/home/aardvarkarmory.com/wwwroot/router.cfm: line 12
272 : 				<cfif Taxonomy.LEVEL EQ 3 and Taxonomy.SUBTYP_1 NEQ ''>
273 : 					and SUBTYP_1 = '#Taxonomy.SUBTYP_1#'
274 : 				<cfelse>
275 : 					and SUBTYP_1 <> 'EMPTY'
276 : 				</cfif>

SQLSTATE   42S22
DATASOURCE   aardvarkicumulus
VENDORERRORCODE   207
SQL    SELECT distinct [DEPT] ,typ ,subtyp as SUBTYP_1 ,web_url FROM tb_ecomm_taxonomy where DEPT = 'Firearms' and typ = 'Handguns' and SUBTYP_1 <> 'EMPTY' and SUBTYP_2 IS NULL and web_url > ''
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   3.80.3.192
Referrer  
Date/Time   20-Oct-21 09:42 AM
Stack Trace
at cfvendcategory2ecfm1428988845._factor6(C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm:274) at cfvendcategory2ecfm1428988845._factor7(C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm:264) at cfvendcategory2ecfm1428988845._factor16(C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm:248) at cfvendcategory2ecfm1428988845.runPage(C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm:1) at cfrouter2ecfm867220999.runPage(C:/home/aardvarkarmory.com/wwwroot/router.cfm:12) at cfvendcategory2ecfm1428988845._factor6(C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm:274) at cfvendcategory2ecfm1428988845._factor7(C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm:264) at cfvendcategory2ecfm1428988845._factor16(C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm:248) at cfvendcategory2ecfm1428988845.runPage(C:/home/aardvarkarmory.com/wwwroot/vendcategory.cfm:1) at cfrouter2ecfm867220999.runPage(C:/home/aardvarkarmory.com/wwwroot/router.cfm:12)

java.sql.SQLSyntaxErrorException: [Macromedia][SQLServer JDBC Driver][SQLServer]Invalid column name 'SUBTYP_1'.
	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.dda4.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:1567)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cfvendcategory2ecfm1428988845._factor6(C:\home\aardvarkarmory.com\wwwroot\vendcategory.cfm:274)
	at cfvendcategory2ecfm1428988845._factor7(C:\home\aardvarkarmory.com\wwwroot\vendcategory.cfm:264)
	at cfvendcategory2ecfm1428988845._factor16(C:\home\aardvarkarmory.com\wwwroot\vendcategory.cfm:248)
	at cfvendcategory2ecfm1428988845.runPage(C:\home\aardvarkarmory.com\wwwroot\vendcategory.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
	at cfrouter2ecfm867220999.runPage(C:\home\aardvarkarmory.com\wwwroot\router.cfm:12)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:594)
	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:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	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:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	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:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:542)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:143)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:359)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:459)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:888)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1597)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:835)