Mach-II Exception

Message

Error Executing Database Query.

Detail

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'.

Extended Info

Tag Context

D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc (3963)

D:\websites\iponlyjazz\calendar\model\service\siteService.cfc (7164)

D:\websites\iponlyjazz\calendar\listeners\siteListener.cfc (2846)

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\calendar\filters\content\displayPageContentFilter.cfc (157)

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 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'. 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 cfsiteGateway2ecfc339498571$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc:3963) 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 cfsiteService2ecfc1801046098$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\service\siteService.cfc:7164) 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 cfsiteListener2ecfc821183994$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\listeners\siteListener.cfc:2846) 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 cfdisplayPageContentFilter2ecfc949783153$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\calendar\filters\content\displayPageContentFilter.cfc:157) 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 3963
RAW_TRACE at cfsiteGateway2ecfc339498571$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc:3963)
TEMPLATE D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 7164
RAW_TRACE at cfsiteService2ecfc1801046098$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\service\siteService.cfc:7164)
TEMPLATE D:\websites\iponlyjazz\calendar\model\service\siteService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 2846
RAW_TRACE at cfsiteListener2ecfc821183994$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\listeners\siteListener.cfc:2846)
TEMPLATE D:\websites\iponlyjazz\calendar\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 157
RAW_TRACE at cfdisplayPageContentFilter2ecfc949783153$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\calendar\filters\content\displayPageContentFilter.cfc:157)
TEMPLATE D:\websites\iponlyjazz\calendar\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 the keyword 'ORDER'.
ErrorCode HY000
Exceptions
array
1
struct
class java.sql.SQLException
message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'.
Message Error Executing Database Query.
NativeErrorCode 156
RootCause
struct
ErrorCode 156
Message [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'.
SQLState HY000
StackTrace java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'ORDER'. 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 cfsiteGateway2ecfc339498571$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc:3963) 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 cfsiteService2ecfc1801046098$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\service\siteService.cfc:7164) 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 cfsiteListener2ecfc821183994$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\listeners\siteListener.cfc:2846) 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 cfdisplayPageContentFilter2ecfc949783153$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\calendar\filters\content\displayPageContentFilter.cfc:157) 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 3963
RAW_TRACE at cfsiteGateway2ecfc339498571$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc:3963)
TEMPLATE D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 7164
RAW_TRACE at cfsiteService2ecfc1801046098$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\service\siteService.cfc:7164)
TEMPLATE D:\websites\iponlyjazz\calendar\model\service\siteService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 2846
RAW_TRACE at cfsiteListener2ecfc821183994$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\listeners\siteListener.cfc:2846)
TEMPLATE D:\websites\iponlyjazz\calendar\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 157
RAW_TRACE at cfdisplayPageContentFilter2ecfc949783153$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\calendar\filters\content\displayPageContentFilter.cfc:157)
TEMPLATE D:\websites\iponlyjazz\calendar\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 SELECT DISTINCT product_tblProductTypes.sortOrder, product_tblProductTypes.productTypeId, product_tblProductTypes.productTypeName, tblMedia.mediaServer, tblMedia.mediaName, tblMedia.path FROM ((product_tblProduct INNER JOIN product_joinProductProductType ON product_tblProduct.productId = product_joinProductProductType.productId) INNER JOIN product_tblProductTypes ON product_joinProductProductType.productTypeId = product_tblProductTypes.productTypeId) LEFT JOIN tblMedia ON product_tblProductTypes.imageId = tblMedia.mediaId WHERE product_tblProduct.siteId = 3601 AND product_tblProduct.vendorId = ORDER BY product_tblProductTypes.sortOrder 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 cfsiteGateway2ecfc339498571$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc:3963) 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 cfsiteService2ecfc1801046098$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\service\siteService.cfc:7164) 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 cfsiteListener2ecfc821183994$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\listeners\siteListener.cfc:2846) 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 cfdisplayPageContentFilter2ecfc949783153$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\calendar\filters\content\displayPageContentFilter.cfc:157) 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 the keyword 'ORDER'. 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 3963
RAW_TRACE at cfsiteGateway2ecfc339498571$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc:3963)
TEMPLATE D:\websites\iponlyjazz\calendar\model\gateway\siteGateway.cfc
TYPE CFML
2
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 7164
RAW_TRACE at cfsiteService2ecfc1801046098$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\model\service\siteService.cfc:7164)
TEMPLATE D:\websites\iponlyjazz\calendar\model\service\siteService.cfc
TYPE CFML
3
struct
COLUMN 0
ID CF_TEMPLATEPROXY
LINE 2846
RAW_TRACE at cfsiteListener2ecfc821183994$funcGETVENDORPRODUCTTYPES.runFunction(D:\websites\iponlyjazz\calendar\listeners\siteListener.cfc:2846)
TEMPLATE D:\websites\iponlyjazz\calendar\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 157
RAW_TRACE at cfdisplayPageContentFilter2ecfc949783153$funcFILTEREVENT.runFunction(D:\websites\iponlyjazz\calendar\filters\content\displayPageContentFilter.cfc:157)
TEMPLATE D:\websites\iponlyjazz\calendar\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 the keyword 'ORDER'.
where [empty string]