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 keyword 'AND'.
 
The error occurred in C:/inetpub/wwwroot/DRIVING/past_event_detail.cfm: line 26
 
24 :     from products
25 :     where venue_name = <cfqueryparam value="#qEvent.venue_name#">
26 :     and event_date < <cfqueryparam cfsqltype="cf_sql_date" value="#CreateODBCDate(qEvent.event_date)#"> AND 
27 :     AND (event_folder is NULL or event_folder = '')
28 :     order by event_date desc
SQLSTATE   HY000
DATASOURCE   driving
VENDORERRORCODE   156
SQL    select program_name, venue_name, event_date, product_id,name from products where venue_name = (param 1) and event_date < (param 2) AND AND (event_folder is NULL or event_folder = '') order by event_date desc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   199.19.156.3
Referrer  
Date/Time   26-Nov-20 12:38 PM
Stack Trace
at cfpast_event_detail2ecfm6391710.runPage(C:/inetpub/wwwroot/DRIVING/past_event_detail.cfm:26) at cfpast_event_detail2ecfm6391710.runPage(C:/inetpub/wwwroot/DRIVING/past_event_detail.cfm:26) 

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near the keyword 'AND'.
	at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.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.ddq.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddf.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddf.execute(Unknown Source)
	at macromedia.jdbc.sqlserverbase.dddj.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunPreparedStatement.execute(JRunPreparedStatement.java:101)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1458)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1056)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:685)
	at cfpast_event_detail2ecfm6391710.runPage(C:\inetpub\wwwroot\DRIVING\past_event_detail.cfm:26)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:443)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	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:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	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:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:210)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)