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 489
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm: line 161
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/g/gnl/ekp.cfm: line 37
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm: line 489
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm: line 161
Called from C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/g/gnl/ekp.cfm: line 37
487 : 	
488 : 	<!--- add sort by EvtName for SanDiego 4.2.3 --->
489 : 	ORDER BY EvtDateTimeBegin<CFIF curOrder EQ 'desc'> DESC</CFIF>, EvtDateTimeEnd, EvtName
490 :     
491 : </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 92=92 AND 555=555 AND EvtOrg = 'GNL' AND 'woof' = 'woof' AND ((evtKeyword1 = 'Childrens Programs') OR (evtKeyword1 LIKE '*%') OR (evtKeyword1 LIKE '-%') OR (evtKeyword1 LIKE '%+ Childrens Programs%') OR (evtKeyword1 = '{ Childrens Programs')) AND 346=346 AND ((evtKeyword2 = 'Parkville') OR (evtKeyword2 LIKE '*%') OR (evtKeyword2 LIKE '-%') OR (evtKeyword2 LIKE '%+ Parkville%') OR (evtKeyword2 = '{ Parkville')) AND (EvtDateTimeEnd >= '04/30/2016') AND 135 = 135 AND 331 = 331 AND ( DatePart(mm,EvtDateTimeBegin) = '4,4' OR DatePart(mm,EvtDateTimeEnd) = '4,4' OR ( DatePart(mm,EvtDateTimeBegin) <4,4 AND DatePart(mm,EvtDateTimeEnd) > 4,4 ) ) AND DatePart(yy,EvtDateTimeBegin) = '2016,2016' AND 13=13 AND ((EvtPostStatus = 'SHOW') OR (EvtPostStatus = 'PUBLIC')) and 125=125 AND ((EvtListDisplay IS NULL) OR (EvtListDisplay <> 'HIDE')) ORDER BY EvtDateTimeBegin, EvtDateTimeEnd, EvtName
Resources:

Browser   claudebot
Remote Address   18.207.98.249
Referrer   http://www.eventkeeper.com/code/events.cfm?curOrg=GNL&curKey1=Childrens%20Programs&curKey2=Parkville&curMonth=4&curYear=2016&curHelp=&curMonth=4&curYear=2016&SelectedDate=4/30/2016
Date/Time   29-Mar-24 09:33 AM
Stack Trace
at cfxp_GetEvents2ecfm1469197816.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm:489) at cfinc_ek_vars2ecfm1486535562.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm:161) at cfekp2ecfm807197181.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/g/gnl/ekp.cfm:37) at cfxp_GetEvents2ecfm1469197816.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/xp_GetEvents.cfm:489) at cfinc_ek_vars2ecfm1486535562.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/incs/inc_ek_vars.cfm:161) at cfekp2ecfm807197181.runPage(C:/inetpub/wwwroot/clients/plymouthrocket.net/www/mars/xpages/g/gnl/ekp.cfm:37)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ','.
	at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddcv.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.c(Unknown Source)
	at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.$fr$execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
	at cfxp_GetEvents2ecfm1469197816.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\incs\xp_GetEvents.cfm:489)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286)
	at cfinc_ek_vars2ecfm1486535562.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\incs\inc_ek_vars.cfm:161)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4286)
	at cfekp2ecfm807197181.runPage(C:\inetpub\wwwroot\clients\plymouthrocket.net\www\mars\xpages\g\gnl\ekp.cfm:37)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
	at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:597)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:96)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:226)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at jdk.internal.reflect.GeneratedMethodAccessor234.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:134)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doNext(FusionReactorRequestHandler.java:698)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doHttpServletRequest(FusionReactorRequestHandler.java:256)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.doFusionRequest(FusionReactorRequestHandler.java:119)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorRequestHandler.handle(FusionReactorRequestHandler.java:736)
	at com.intergral.fusionreactor.j2ee.filter.FusionReactorCoreFilter.doFilter(FusionReactorCoreFilter.java:36)
	at jdk.internal.reflect.GeneratedMethodAccessor66.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at com.intergral.fusionreactor.j2ee.filterchain.WrappedFilterChain.doFilter(WrappedFilterChain.java:71)
	at jdk.internal.reflect.GeneratedMethodAccessor65.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at com.intergral.fusionreactor.agent.filter.FusionReactorStaticFilter.doFilter(FusionReactorStaticFilter.java:54)
	at com.intergral.fusionreactor.agent.pointcuts.NewFilterChainPointCut$1.invoke(NewFilterChainPointCut.java:50)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:451)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.base/java.lang.Thread.run(Thread.java:834)