struct
EVENTNAME	onRequest
EXCEPTION	struct Cause struct Cause struct ErrorCode 102 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. SQLState HY000 StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4132) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4112) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.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:4286) at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.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:4286) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) 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:4286) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) 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:4286) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 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) Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 131 RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 2 struct COLUMN 0 ID CF_UDFMETHOD LINE 46 RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 3 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 4 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 5 struct COLUMN 0 ID CFINCLUDE LINE 199 RAW_TRACE at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 6 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 7 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 8 struct COLUMN 0 ID CFINCLUDE LINE 34 RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) TEMPLATE E:\websites\includes\views\landingPage.cfm TYPE CFML 9 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) TEMPLATE E:\websites\defaultWebsite_rp\category.cfm TYPE CFML 10 struct COLUMN 0 ID CFINCLUDE LINE 125 RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) TEMPLATE E:\websites\defaultWebsite_rp\application.cfc TYPE CFML Type java.sql.SQLException DataSource koalaSQL Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. ErrorCode HY000 Exceptions array 1 struct class java.sql.SQLException message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. Message Error Executing Database Query. NativeErrorCode 102 RootCause struct ErrorCode 102 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. SQLState HY000 StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4132) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4112) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.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:4286) at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.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:4286) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) 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:4286) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) 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:4286) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 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) Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 131 RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 2 struct COLUMN 0 ID CF_UDFMETHOD LINE 46 RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 3 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 4 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 5 struct COLUMN 0 ID CFINCLUDE LINE 199 RAW_TRACE at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 6 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 7 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 8 struct COLUMN 0 ID CFINCLUDE LINE 34 RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) TEMPLATE E:\websites\includes\views\landingPage.cfm TYPE CFML 9 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) TEMPLATE E:\websites\defaultWebsite_rp\category.cfm TYPE CFML 10 struct COLUMN 0 ID CFINCLUDE LINE 125 RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) TEMPLATE E:\websites\defaultWebsite_rp\application.cfc TYPE CFML Type java.sql.SQLException SQLState HY000 Sql SELECT DISTINCT typ, count(distinct style_id) as itemCount FROM web_all_products WHERE ltrim(rtrim(dept))='Soccer Plus' and upper(typ)<>'EMPTY' and style_id IN () GROUP BY typ StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4132) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4112) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.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:4286) at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.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:4286) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) 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:4286) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) 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:4286) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 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) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) ... 87 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 131 RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 2 struct COLUMN 0 ID CF_UDFMETHOD LINE 46 RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 3 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 4 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 5 struct COLUMN 0 ID CFINCLUDE LINE 199 RAW_TRACE at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 6 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 7 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 8 struct COLUMN 0 ID CFINCLUDE LINE 34 RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) TEMPLATE E:\websites\includes\views\landingPage.cfm TYPE CFML 9 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) TEMPLATE E:\websites\defaultWebsite_rp\category.cfm TYPE CFML 10 struct COLUMN 0 ID CFINCLUDE LINE 125 RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) TEMPLATE E:\websites\defaultWebsite_rp\application.cfc TYPE CFML Type Database queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. where [empty string] Detail An exception occurred while invoking an event handler method from Application.cfc. The method name is: onRequest. Message Event handler exception. RootCause struct Cause struct ErrorCode 102 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. SQLState HY000 StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4132) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4112) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.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:4286) at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.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:4286) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) 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:4286) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) 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:4286) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 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) Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 131 RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 2 struct COLUMN 0 ID CF_UDFMETHOD LINE 46 RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 3 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 4 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 5 struct COLUMN 0 ID CFINCLUDE LINE 199 RAW_TRACE at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 6 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 7 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 8 struct COLUMN 0 ID CFINCLUDE LINE 34 RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) TEMPLATE E:\websites\includes\views\landingPage.cfm TYPE CFML 9 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) TEMPLATE E:\websites\defaultWebsite_rp\category.cfm TYPE CFML 10 struct COLUMN 0 ID CFINCLUDE LINE 125 RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) TEMPLATE E:\websites\defaultWebsite_rp\application.cfc TYPE CFML Type java.sql.SQLException DataSource koalaSQL Detail [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. ErrorCode HY000 Exceptions array 1 struct class java.sql.SQLException message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. Message Error Executing Database Query. NativeErrorCode 102 RootCause struct ErrorCode 102 Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. SQLState HY000 StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4132) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4112) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.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:4286) at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.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:4286) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) 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:4286) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) 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:4286) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 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) Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 131 RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 2 struct COLUMN 0 ID CF_UDFMETHOD LINE 46 RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 3 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 4 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 5 struct COLUMN 0 ID CFINCLUDE LINE 199 RAW_TRACE at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 6 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 7 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 8 struct COLUMN 0 ID CFINCLUDE LINE 34 RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) TEMPLATE E:\websites\includes\views\landingPage.cfm TYPE CFML 9 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) TEMPLATE E:\websites\defaultWebsite_rp\category.cfm TYPE CFML 10 struct COLUMN 0 ID CFINCLUDE LINE 125 RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) TEMPLATE E:\websites\defaultWebsite_rp\application.cfc TYPE CFML Type java.sql.SQLException SQLState HY000 Sql SELECT DISTINCT typ, count(distinct style_id) as itemCount FROM web_all_products WHERE ltrim(rtrim(dept))='Soccer Plus' and upper(typ)<>'EMPTY' and style_id IN () GROUP BY typ StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4132) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4112) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.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:4286) at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.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:4286) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) 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:4286) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) 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:4286) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 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) Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) ... 87 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 131 RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 2 struct COLUMN 0 ID CF_UDFMETHOD LINE 46 RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 3 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 4 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 5 struct COLUMN 0 ID CFINCLUDE LINE 199 RAW_TRACE at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 6 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 7 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 8 struct COLUMN 0 ID CFINCLUDE LINE 34 RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) TEMPLATE E:\websites\includes\views\landingPage.cfm TYPE CFML 9 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) TEMPLATE E:\websites\defaultWebsite_rp\category.cfm TYPE CFML 10 struct COLUMN 0 ID CFINCLUDE LINE 125 RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) TEMPLATE E:\websites\defaultWebsite_rp\application.cfc TYPE CFML Type Database queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. where [empty string] StackTrace coldfusion.runtime.EventHandlerException: Event handler exception. at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:319) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:553) 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:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587) 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) Caused by: coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:894) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794) at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4132) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:4112) at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.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:4286) at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.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:4286) at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) 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:4286) at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) 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:4286) at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:553) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:484) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:447) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:398) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:371) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:287) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:830) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:613) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:438) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:115) at coldfusion.runtime.AppEventInvoker.onRequest(AppEventInvoker.java:308) ... 40 more Caused by: java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'. 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.setupCachedQuery(QueryTag.java:1131) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:833) ... 87 more Suppressed array[empty] TagContext array 1 struct COLUMN 0 ID CFQUERY LINE 131 RAW_TRACE at cfdepartments2ecfm869023367$funcCREATETAXONOMYLIST.runFunction(E:\websites\includes_rp\departments.cfm:131) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 2 struct COLUMN 0 ID CF_UDFMETHOD LINE 46 RAW_TRACE at cfdepartments2ecfm869023367._factor0(E:\websites\includes_rp\departments.cfm:46) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 3 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367._factor17(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 4 struct COLUMN 0 ID CF_DEPARTMENTS LINE 1 RAW_TRACE at cfdepartments2ecfm869023367.runPage(E:\websites\includes_rp\departments.cfm:1) TEMPLATE E:\websites\includes_rp\departments.cfm TYPE CFML 5 struct COLUMN 0 ID CFINCLUDE LINE 199 RAW_TRACE at cfsidenav2ecfm1602545999._factor45(E:\websites\includes_rp\sidenav.cfm:199) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 6 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999._factor50(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 7 struct COLUMN 0 ID CF_SIDENAV LINE 1 RAW_TRACE at cfsidenav2ecfm1602545999.runPage(E:\websites\includes_rp\sidenav.cfm:1) TEMPLATE E:\websites\includes_rp\sidenav.cfm TYPE CFML 8 struct COLUMN 0 ID CFINCLUDE LINE 34 RAW_TRACE at cflandingPage2ecfm1286080305.runPage(E:\websites\includes\views\landingPage.cfm:34) TEMPLATE E:\websites\includes\views\landingPage.cfm TYPE CFML 9 struct COLUMN 0 ID CFINCLUDE LINE 75 RAW_TRACE at cfcategory2ecfm181038206.runPage(E:\websites\defaultWebsite_rp\category.cfm:75) TEMPLATE E:\websites\defaultWebsite_rp\category.cfm TYPE CFML 10 struct COLUMN 0 ID CFINCLUDE LINE 125 RAW_TRACE at cfapplication2ecfc440582658$funcONREQUEST.runFunction(E:\websites\defaultWebsite_rp\application.cfc:125) TEMPLATE E:\websites\defaultWebsite_rp\application.cfc TYPE CFML Type Database name onRequest