Cooling & Heating - Dawes Motorsports - Porsche Race Engine Builders

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 (7196)

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

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

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

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

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

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

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

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

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

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

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

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

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

D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm (167)

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

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.$fr$execute(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:1531) at coldfusion.sql.Executive.executeQuery(Executive.java:1281) at coldfusion.sql.Executive.executeQuery(Executive.java:1211) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1202) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3017) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2992) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:477) at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:92) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:377) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3017) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2992) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:477) at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:117) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:91) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:466) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:416) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:362) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfRequestHandler2ecfc982427979$funcHANDLEEVENTREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:268) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:134) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3017) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2992) at cfcommon2ecfm132296628$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm:167) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:109) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) 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:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) 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:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:363) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:507) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 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

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	7196
RAW_TRACE	at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7196)
TEMPLATE	D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	92
RAW_TRACE	at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:92)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	377
RAW_TRACE	at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:377)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	117
RAW_TRACE	at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:117)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	91
RAW_TRACE	at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:91)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	466
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:466)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	416
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:416)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	362
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:362)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	268
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENTREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:268)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	134
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:134)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	167
RAW_TRACE	at cfcommon2ecfm132296628$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm:167)
TEMPLATE	D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	109
RAW_TRACE	at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:109)
TEMPLATE	D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

StackTrace

Suppressed

array [empty]

TagContext

array

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	7196
RAW_TRACE	at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7196)
TEMPLATE	D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	92
RAW_TRACE	at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:92)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	377
RAW_TRACE	at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:377)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	117
RAW_TRACE	at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:117)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	91
RAW_TRACE	at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:91)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	466
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:466)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	416
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:416)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	362
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:362)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	268
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENTREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:268)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	134
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:134)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	167
RAW_TRACE	at cfcommon2ecfm132296628$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm:167)
TEMPLATE	D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	109
RAW_TRACE	at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:109)
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

struct
class	java.sql.SQLException
message	[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.

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

Suppressed

array [empty]

TagContext

array

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	7196
RAW_TRACE	at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7196)
TEMPLATE	D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	92
RAW_TRACE	at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:92)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	377
RAW_TRACE	at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:377)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	117
RAW_TRACE	at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:117)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	91
RAW_TRACE	at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:91)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	466
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:466)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	416
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:416)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	362
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:362)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	268
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENTREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:268)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	134
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:134)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	167
RAW_TRACE	at cfcommon2ecfm132296628$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm:167)
TEMPLATE	D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	109
RAW_TRACE	at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:109)
TEMPLATE	D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE	CFML

Type

java.sql.SQLException

SQLState

HY000

StackTrace

Suppressed

array [empty]

TagContext

array

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	7196
RAW_TRACE	at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7196)
TEMPLATE	D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	92
RAW_TRACE	at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:92)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	377
RAW_TRACE	at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:377)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	117
RAW_TRACE	at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:117)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	91
RAW_TRACE	at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:91)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	466
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:466)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	416
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:416)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	362
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:362)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	268
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENTREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:268)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	134
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:134)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	167
RAW_TRACE	at cfcommon2ecfm132296628$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm:167)
TEMPLATE	D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	109
RAW_TRACE	at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:109)
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:866) at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:768) at cfsiteGateway2ecfc639030197$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\gateway\siteGateway.cfc:4668) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7196) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfsiteListener2ecfc874705947$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\listeners\siteListener.cfc:2787) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3017) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2992) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:477) at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:92) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfNotifyCommand2ecfc1028019299$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\NotifyCommand.cfc:95) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfSubroutineHandler2ecfc1478137573$funcHANDLESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\SubroutineHandler.cfc:83) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:377) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfdisplayPageContentFilter2ecfc386132536$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\CCEM\filters\content\displayPageContentFilter.cfc:175) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3017) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2992) at coldfusion.tagext.lang.InvokeTag.doEndTag(InvokeTag.java:477) at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:117) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:91) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3095) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3072) at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:466) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:416) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:362) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfRequestHandler2ecfc982427979$funcHANDLEEVENTREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:268) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:134) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:538) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:464) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:3017) at coldfusion.runtime.CfJspPage._invoke(CfJspPage.java:2992) at cfcommon2ecfm132296628$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm:167) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3542) at coldfusion.runtime.CfJspPage._invokeUDF(CfJspPage.java:3522) at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:109) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:492) at coldfusion.runtime.UDFMethod$ReturnTypeFilter.invoke(UDFMethod.java:425) at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:388) at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:95) at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:339) at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:234) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:650) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:439) at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:409) at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:114) at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:285) at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:473) at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43) 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:60) at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38) at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22) at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62) at coldfusion.CfmServlet.service(CfmServlet.java:219) at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) 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:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165) at sun.reflect.GeneratedMethodAccessor105.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:772) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:344) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:207) at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:809) at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36) at sun.reflect.GeneratedMethodAccessor116.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71) at sun.reflect.GeneratedMethodAccessor61.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54) at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:42) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:474) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:363) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:507) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:798) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1434) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) 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.$fr$execute(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:1531) at coldfusion.sql.Executive.executeQuery(Executive.java:1281) at coldfusion.sql.Executive.executeQuery(Executive.java:1211) at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406) at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1202) at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:815) ... 250 more

Suppressed

array [empty]

TagContext

array

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	7196
RAW_TRACE	at cfsiteService2ecfc1499942632$funcGETPRODUCTSBYTYPE.runFunction(D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc:7196)
TEMPLATE	D:\websites\iponlyjazz\CCEM\model\service\siteService.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	92
RAW_TRACE	at cfEventInvoker2ecfc903570489$funcINVOKELISTENER.runFunction(D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc:92)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\invokers\EventInvoker.cfc
TYPE	CFML

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

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

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	377
RAW_TRACE	at cfEventContext2ecfc2025868933$funcEXECUTESUBROUTINE.runFunction(D:\websites\iponlyjazz\MachII\framework\EventContext.cfc:377)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventContext.cfc
TYPE	CFML

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

struct
COLUMN	0
ID	CFINVOKE
LINE	117
RAW_TRACE	at cfFilterCommand2ecfc1255279632$funcEXECUTE.runFunction(D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc:117)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\commands\FilterCommand.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	91
RAW_TRACE	at cfEventHandler2ecfc656104769$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc:91)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\EventHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	466
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:466)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	416
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLENEXTEVENT.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:416)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	362
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcPROCESSEVENTS.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:362)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	268
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEEVENTREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:268)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	134
RAW_TRACE	at cfRequestHandler2ecfc982427979$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc:134)
TEMPLATE	D:\websites\iponlyjazz\MachII\framework\RequestHandler.cfc
TYPE	CFML

struct
COLUMN	0
ID	CF_TEMPLATEPROXY
LINE	167
RAW_TRACE	at cfcommon2ecfm132296628$funcHANDLEREQUEST.runFunction(D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm:167)
TEMPLATE	D:\websites\iponlyjazz\MachII\bootstrapper\common.cfm
TYPE	CFML

struct
COLUMN	0
ID	CF_UDFMETHOD
LINE	109
RAW_TRACE	at cfmach2dii2ecfc1594721273$funcONREQUESTSTART.runFunction(D:\websites\iponlyjazz\MachII\mach-ii.cfc:109)
TEMPLATE	D:\websites\iponlyjazz\MachII\mach-ii.cfc
TYPE	CFML

Type

Database

queryError

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

where

[empty string]