List Calendar View

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/bloom/ek.cfm: line 193
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/bloom/ek.cfm: line 193
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 = 'BLOOM' AND 'woof' = 'woof' AND ((evtKeyword1 = 'Adult Programs') OR (evtKeyword1 LIKE '*%') OR (evtKeyword1 LIKE '-%') OR (evtKeyword1 LIKE '%+ Adult Programs%') OR (evtKeyword1 = '{ Adult Programs')) AND (EvtDateTimeEnd >= '04/12/2012') AND 135 = 135 AND 331 = 331 AND ( DatePart(mm,EvtDateTimeBegin) = '3,4' OR DatePart(mm,EvtDateTimeEnd) = '3,4' OR ( DatePart(mm,EvtDateTimeBegin) <3,4 AND DatePart(mm,EvtDateTimeEnd) > 3,4 ) ) AND DatePart(yy,EvtDateTimeBegin) = '2012,2012' 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.167.126.106
Referrer  
Date/Time   20-Jan-18 06:04 PM
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 cfek2ecfm201671506.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/bloom/ek.cfm:193) 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 cfek2ecfm201671506.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/b/bloom/ek.cfm:193)

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 cfek2ecfm201671506.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\xpages\b\bloom\ek.cfm:193)
	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.GeneratedMethodAccessor53.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.GeneratedMethodAccessor51.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.GeneratedMethodAccessor50.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)