Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ','.
 
The error occurred in C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm: line 414
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm: line 125
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/w/wpl/ek.cfm: line 300
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm: line 414
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm: line 125
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/w/wpl/ek.cfm: line 300
412 : 	
413 : 	<!--- add sort by EvtName for SanDiego 4.2.3 --->
414 : 	ORDER BY EvtDateTimeBegin<CFIF curOrder EQ 'desc'> DESC</CFIF>, EvtDateTimeEnd, EvtName
415 :     
416 : </cfquery>     

SQLSTATE   HY000
DATASOURCE   dsn_EK_1395
VENDORERRORCODE   102
SQL    SELECT EvtID, EvtIconName, EvtName, EvtNameForCal, EvtDateTimeBegin, EvtDateTimeEnd, EvtTimeBeginExists, EvtTimeEndExists, EvtPostStatus, EvtKeyword1, EvtDescription, EvtEditorNotes, EvtOrg, EvtContactName, EvtContactPhone, EvtContactEmail, EvtLocationText, EvtUrlText,EvtUrl,EvtNameColor, EvtDynaFormID, EvtListDisplay FROM events WITH (NOLOCK) WHERE 24=24 AND EvtOrg = 'WPL' AND 'woof' = 'woof' AND ((evtKeyword1 = 'Classes') OR (evtKeyword1 LIKE '*%') OR (evtKeyword1 LIKE '-%') OR (evtKeyword1 LIKE '%+ Classes%') OR (evtKeyword1 = '{ Classes')) AND ( DatePart(mm,EvtDateTimeBegin) = '9,8' OR DatePart(mm,EvtDateTimeEnd) = '9,8' OR ( DatePart(mm,EvtDateTimeBegin) <9,8 AND DatePart(mm,EvtDateTimeEnd) > 9,8 ) ) AND DatePart(yy,EvtDateTimeBegin) = '2013,2013' AND ((EvtPostStatus = 'SHOW') OR (EvtPostStatus = 'PUBLIC')) and 125=125 AND ((EvtListDisplay IS NULL) OR ((EvtListDisplay <> 'HIDE') AND (EvtListDisplay <> 'BUSY'))) ORDER BY EvtDateTimeBegin, EvtDateTimeEnd, EvtName
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.161.96.152
Referrer  
Date/Time   27-May-17 07:56 AM
Stack Trace
at cfxp_GetEvents2ecfm1469197816.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm:414) at cfinc_ek_vars2ecfm1486535562.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm:125) at cfek2ecfm96677552.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/w/wpl/ek.cfm:300) at cfxp_GetEvents2ecfm1469197816.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm:414) at cfinc_ek_vars2ecfm1486535562.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm:125) at cfek2ecfm96677552.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/w/wpl/ek.cfm:300)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ','.
	at macromedia.jdbc.sqlserverbase.dda4.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda4.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dda3.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.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.l(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddde.execute(Unknown Source)
	at com.intergral.fusionreactor.jdbc.StatementSurrogate.execute(StatementSurrogate.java:63)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:348)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1420)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1183)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1114)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:341)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:915)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:590)
	at cfxp_GetEvents2ecfm1469197816.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\incs\xp_GetEvents.cfm:414)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfinc_ek_vars2ecfm1486535562.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\incs\inc_ek_vars.cfm:125)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfek2ecfm96677552.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\xpages\w\wpl\ek.cfm:300)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:416)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:381)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:94)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:70)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:46)
	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:200)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:86)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java:94)
	at sun.reflect.GeneratedMethodAccessor32.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:97)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:472)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:499)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor31.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:79)
	at sun.reflect.GeneratedMethodAccessor30.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:53)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:41)
	at jrun.servlet.FilterChain.doFilter(FilterChain.java)
	at jrun.servlet.FilterChain.service(FilterChain.java:101)
	at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:106)
	at jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
	at jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatcher.java:286)
	at jrun.servlet.ServletEngineService.dispatch(ServletEngineService.java:543)
	at jrun.servlet.jrpp.JRunProxyService.invokeRunnable(JRunProxyService.java:203)
	at jrunx.scheduler.ThreadPool$DownstreamMetrics.invokeRunnable(ThreadPool.java:320)
	at jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(ThreadPool.java:428)
	at jrunx.scheduler.ThreadPool$UpstreamMetrics.invokeRunnable(ThreadPool.java:266)
	at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)