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.


Query Of Queries syntax error.
Encountered "dept.
 
The error occurred in C:/inetpub/wwwroot/queries/qry_getwebproducts.cfm: line 41
Called from C:/inetpub/wwwroot/category.cfm: line 52
Called from C:/inetpub/wwwroot/queries/qry_getwebproducts.cfm: line 41
Called from C:/inetpub/wwwroot/category.cfm: line 52
39 : 			</cfif>
40 : 			<cfif len(subtyp_3) and url.subtyp_3 neq 'EMPTY'>
41 : 				and subtyp_3 = '#trim(url.subtyp_3)#'
42 : 			</cfif>
43 :         	

SQL    SELECT * FROM grandgetproducts WHERE 1=1 dept='Clothing & Accessories'
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.211.207.116
Referrer  
Date/Time   07-Dec-16 08:03 PM
Stack Trace
at cfqry_getwebproducts2ecfm598189368.runPage(C:/inetpub/wwwroot/queries/qry_getwebproducts.cfm:41) at cfcategory2ecfm875314043.runPage(C:/inetpub/wwwroot/category.cfm:52) at cfqry_getwebproducts2ecfm598189368.runPage(C:/inetpub/wwwroot/queries/qry_getwebproducts.cfm:41) at cfcategory2ecfm875314043.runPage(C:/inetpub/wwwroot/category.cfm:52)

java.sql.SQLException: <br><b>Query Of Queries syntax error.</b><br>
Encountered "dept.

	at coldfusion.sql.imq.jdbcStatement.parseSQL(jdbcStatement.java:590)
	at coldfusion.sql.imq.jdbcStatement.fetchResult(jdbcStatement.java:547)
	at coldfusion.sql.imq.jdbcStatement.execute(jdbcStatement.java:142)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1489)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:411)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1185)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:814)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:767)
	at cfqry_getwebproducts2ecfm598189368.runPage(C:\inetpub\wwwroot\queries\qry_getwebproducts.cfm:41)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	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:2991)
	at cfcategory2ecfm875314043.runPage(C:\inetpub\wwwroot\category.cfm:52)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:246)
	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:487)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:42)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:142)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	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: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:220)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:450)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
	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)