Mach-II Exception

Message

Error Executing Database Query.

Detail

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.

Extended Info

Tag Context

D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc (4668)

D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc (7195)

D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc (2787)

D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc (94)

D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc (95)

D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc (83)

D:\websites\iponlyjazz\MachII\framework\EventContext.cfc (379)

D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc (175)

D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc (103)

D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc (88)

D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc (386)

D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc (334)

D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc (278)

D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc (208)

D:\websites\iponlyjazz\MachII\mach-ii.cfc (210)

D:\websites\iponlyjazz\MachII\mach-ii.cfc (121)

Caught Exception

struct
Cause
struct
ErrorCode 102
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
NextException
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.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.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:279) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:463) 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.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:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) 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:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) 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(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 4668
RAW_TRACE at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 7195
RAW_TRACE at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 2787
RAW_TRACE at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787)
TEMPLATE D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc
TYPE CFML
4
struct
COLUMN 0
ID CFINVOKE
LINE 94
RAW_TRACE at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 95
RAW_TRACE at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 83
RAW_TRACE at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 379
RAW_TRACE at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 175
RAW_TRACE at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175)
TEMPLATE D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc
TYPE CFML
9
struct
COLUMN 0
ID CFINVOKE
LINE 103
RAW_TRACE at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 88
RAW_TRACE at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE CFML
11
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 386
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
12
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 334
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
13
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 278
RAW_TRACE at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
14
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 208
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
15
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 210
RAW_TRACE at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
16
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 121
RAW_TRACE at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
Type java.sql.SQLException
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.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.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:279) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:463) 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.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:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) 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:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) 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(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 4668
RAW_TRACE at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 7195
RAW_TRACE at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 2787
RAW_TRACE at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787)
TEMPLATE D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc
TYPE CFML
4
struct
COLUMN 0
ID CFINVOKE
LINE 94
RAW_TRACE at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 95
RAW_TRACE at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 83
RAW_TRACE at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 379
RAW_TRACE at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 175
RAW_TRACE at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175)
TEMPLATE D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc
TYPE CFML
9
struct
COLUMN 0
ID CFINVOKE
LINE 103
RAW_TRACE at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 88
RAW_TRACE at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE CFML
11
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 386
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
12
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 334
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
13
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 278
RAW_TRACE at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
14
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 208
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
15
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 210
RAW_TRACE at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
16
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 121
RAW_TRACE at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
Type java.sql.SQLException
DataSource sitemaster2k4
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 ')'.
2
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 ')'.
NextException
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.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.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:279) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:463) 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.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:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) 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:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) 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(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 4668
RAW_TRACE at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 7195
RAW_TRACE at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 2787
RAW_TRACE at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787)
TEMPLATE D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc
TYPE CFML
4
struct
COLUMN 0
ID CFINVOKE
LINE 94
RAW_TRACE at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 95
RAW_TRACE at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 83
RAW_TRACE at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 379
RAW_TRACE at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 175
RAW_TRACE at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175)
TEMPLATE D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc
TYPE CFML
9
struct
COLUMN 0
ID CFINVOKE
LINE 103
RAW_TRACE at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 88
RAW_TRACE at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE CFML
11
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 386
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
12
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 334
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
13
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 278
RAW_TRACE at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
14
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 208
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
15
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 210
RAW_TRACE at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
16
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 121
RAW_TRACE at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
Type java.sql.SQLException
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.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.startQueryExecution(QueryTag.java:816) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:279) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:463) 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.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:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) 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:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) 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(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745)
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 4668
RAW_TRACE at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 7195
RAW_TRACE at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 2787
RAW_TRACE at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787)
TEMPLATE D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc
TYPE CFML
4
struct
COLUMN 0
ID CFINVOKE
LINE 94
RAW_TRACE at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 95
RAW_TRACE at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 83
RAW_TRACE at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 379
RAW_TRACE at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 175
RAW_TRACE at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175)
TEMPLATE D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc
TYPE CFML
9
struct
COLUMN 0
ID CFINVOKE
LINE 103
RAW_TRACE at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 88
RAW_TRACE at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE CFML
11
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 386
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
12
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 334
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
13
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 278
RAW_TRACE at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
14
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 208
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
15
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 210
RAW_TRACE at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
16
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 121
RAW_TRACE at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
Type java.sql.SQLException
SQLState HY000
Sql DECLARE @count int SELECT @count = count(DISTINCT product_tblProduct.productId) FROM (product_tblProduct INNER JOIN product_joinProductProductType ON product_tblProduct.productId = product_joinProductProductType.productId) WHERE product_tblProduct.siteId = 2583 AND (product_tblProduct.productName LIKE '%%' OR product_tblProduct.productBrief LIKE '%%' OR product_tblProduct.productDescription LIKE '%%') AND product_joinProductProductType.productTypeId IN() AND active = 1 SELECT q.price, q.productDescription, q.productDetails, q.productTechnical, q.productBrief, tblMetaData.metaTitle, q.productHyperlink, q.ptSort, q.itemNo, q.productVendorName, q.productId, q.productSubTitle,q.productName, q.imageId, m.mediaName, m.path, m.mediaServer, @count AS totalCount, 'false' AS showImage, 'false' AS goToProduct, (SELECT TOP 1 CAST(price AS decimal(10,2)) AS priceAsNum FROM product_tblVariation WHERE productId = q.productId AND price <> '' ORDER BY priceAsNum ASC) AS lowPrice, (SELECT TOP 1 CAST(price AS decimal(10,2)) AS priceAsNum FROM product_tblVariation WHERE productId = q.productId AND price <> '' ORDER BY priceAsNum DESC) AS highPrice, (SELECT TOP 1 salePrice FROM product_tblVariation WHERE productId = q.productId AND salePrice <> '' ORDER BY salePrice ASC) AS lowSalePrice, (SELECT TOP 1 salePrice FROM product_tblVariation WHERE productId = q.productId AND salePrice <> '' ORDER BY salePrice DESC) AS highSalePrice, (SELECT TOP 1 membersalePrice FROM product_tblVariation WHERE productId = q.productId AND membersalePrice <> '' ORDER BY membersalePrice ASC) AS lowMemberSalePrice, (SELECT TOP 1 membersalePrice FROM product_tblVariation WHERE productId = q.productId AND membersalePrice <> '' ORDER BY membersalePrice DESC) AS highMemberSalePrice, (SELECT TOP 1 wholesalesalePrice FROM product_tblVariation WHERE productId = q.productId AND wholesalesalePrice <> '' ORDER BY wholesalesalePrice ASC) AS lowwholesaleSalePrice, (SELECT TOP 1 wholesalesalePrice FROM product_tblVariation WHERE productId = q.productId AND wholesalesalePrice <> '' ORDER BY wholesalesalePrice DESC) AS highwholesaleSalePrice, (SELECT TOP 1 memberPrice FROM product_tblVariation WHERE productId = q.productId AND memberPrice <> '' ORDER BY memberPrice ASC) AS lowMemberPrice, (SELECT TOP 1 memberPrice FROM product_tblVariation WHERE productId = q.productId AND memberPrice <> '' ORDER BY memberPrice DESC) AS highMemberPrice, (SELECT TOP 1 wholesalePrice FROM product_tblVariation WHERE productId = q.productId AND wholesalePrice <> '' ORDER BY wholesalePrice ASC) AS lowWholesalePrice, (SELECT TOP 1 wholesalePrice FROM product_tblVariation WHERE productId = q.productId AND wholesalePrice <> '' ORDER BY wholesalePrice DESC) AS highWholesalePrice FROM ( SELECT q2.productVendorName, q2.productDescription, q2.productDetails, q2.productTechnical, q2.productBrief, q2.productHyperlink, q2.price, q2.itemNo, q2.productId, q2.ptSort, q2.productName, q2.productSubTitle, q2.imageId, ROW_NUMBER() OVER (ORDER BY q2.ptSort) AS RowNumber FROM ( SELECT product_joinProductProductType.sortOrder AS ptSort, product_tblProduct.productHyperlink, product_tblProduct.price, product_tblProduct.itemNo, product_tblProduct.productId, product_tblProduct.productDescription, product_tblProduct.productDetails, product_tblProduct.productTechnical, product_tblProduct.productBrief, product_tblProduct.productName, product_tblProduct.productSubTitle, product_tblProduct.imageId, product_tblVendor.productVendorName FROM (product_tblProduct INNER JOIN product_joinProductProductType ON product_tblProduct.productId = product_joinProductProductType.productId) LEFT JOIN product_tblVendor ON product_tblProduct.vendorId = product_tblVendor.productvendorId WHERE product_tblProduct.siteId = 2583 AND product_joinProductProductType.productTypeId IN() AND active = 1 AND (product_tblProduct.productName LIKE '%%' OR product_tblProduct.productBrief LIKE '%%' OR product_tblProduct.productDescription LIKE '%%') ) AS q2 ) AS q LEFT JOIN tblMedia AS m ON q.imageId = m.mediaId LEFT JOIN tblMetaData ON q.productId = tblMetaData.dynamicId AND tblMetaData.metaTypeId = 3 WHERE q.RowNumber BETWEEN 1 AND 25 ORDER BY q.ptSort ASC
StackTrace coldfusion.tagext.sql.QueryTag$DatabaseQueryException: Error Executing Database Query. at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:867) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:769) at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:533) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:648) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:457) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2424) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:406) at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2483) at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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.CfJspPage._invokeUDF(CfJspPage.java:2854) at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:487) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:420) 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:643) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:432) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:402) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:279) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:463) 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.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:218) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506) 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:466) at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197) 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(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:745) 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.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.startQueryExecution(QueryTag.java:816) ... 203 more
Suppressed
array [empty]
TagContext
array
1
struct
COLUMN 0
ID CFQUERY
LINE 4668
RAW_TRACE at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 7195
RAW_TRACE at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7195)
TEMPLATE D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 2787
RAW_TRACE at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787)
TEMPLATE D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc
TYPE CFML
4
struct
COLUMN 0
ID CFINVOKE
LINE 94
RAW_TRACE at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:94)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE CFML
5
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 95
RAW_TRACE at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc
TYPE CFML
6
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 83
RAW_TRACE at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc
TYPE CFML
7
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 379
RAW_TRACE at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:379)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE CFML
8
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 175
RAW_TRACE at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175)
TEMPLATE D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc
TYPE CFML
9
struct
COLUMN 0
ID CFINVOKE
LINE 103
RAW_TRACE at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:103)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE CFML
10
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 88
RAW_TRACE at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:88)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE CFML
11
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 386
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:386)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
12
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 334
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:334)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
13
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 278
RAW_TRACE at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:278)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
14
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 208
RAW_TRACE at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:208)
TEMPLATE D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE CFML
15
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 210
RAW_TRACE at cfmach2dii2ecfc1594721273$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:210)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
16
struct
COLUMN 0
ID CF_UDFMETHOD
LINE 121
RAW_TRACE at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:121)
TEMPLATE D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE CFML
Type Database
queryError [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
where [empty string]