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 430
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm: line 130
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/blngham/ekp.cfm: line 37
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm: line 430
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm: line 130
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/blngham/ekp.cfm: line 37
428 : 	
429 : 	<!--- add sort by EvtName for SanDiego 4.2.3 --->
430 : 	ORDER BY EvtDateTimeBegin<CFIF curOrder EQ 'desc'> DESC</CFIF>, EvtDateTimeEnd, EvtName
431 :     
432 : </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, EvtNote1ID, EvtNote1Text FROM events /* xp_GetEvents.cfm : 64 */ WITH (NOLOCK) WHERE 24=24 AND 68=68 AND EvtOrg = 'BLNGHAM' AND ((evtKeyword1 is null) OR (evtKeyword1 NOT LIKE '~%')) AND ((evtKeyword2 is null) OR (evtKeyword2 NOT LIKE '~%')) AND (EvtDateTimeEnd >= '02/25/2014') AND 135 = 135 AND 331 = 331 AND ( DatePart(mm,EvtDateTimeBegin) = '2,2' OR DatePart(mm,EvtDateTimeEnd) = '2,2' OR ( DatePart(mm,EvtDateTimeBegin) <2,2 AND DatePart(mm,EvtDateTimeEnd) > 2,2 ) ) AND DatePart(yy,EvtDateTimeBegin) = '2014,2014' AND 13=13 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.108.158
Referrer  
Date/Time   20-Nov-17 02:55 AM
Stack Trace
at cfxp_GetEvents2ecfm1469197816.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm:430) at cfinc_ek_vars2ecfm1486535562.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm:130) at cfekp2ecfm714398173.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/blngham/ekp.cfm:37) at cfxp_GetEvents2ecfm1469197816.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm:430) at cfinc_ek_vars2ecfm1486535562.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm:130) at cfekp2ecfm714398173.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/blngham/ekp.cfm:37)

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.jdbc42.StatementSurrogate2.execute(StatementSurrogate2.java:49)
	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:430)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418)
	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:130)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2722)
	at cfekp2ecfm714398173.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\xpages\b\blngham\ekp.cfm:37)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:231)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:418)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:399)
	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:78)
	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:201)
	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.GeneratedMethodAccessor351.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:770)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:339)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:215)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:807)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at sun.reflect.GeneratedMethodAccessor405.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.GeneratedMethodAccessor259.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)