[Hockey][Mr.Sports]
[Football] [Basketball] [Baseball]
[Teams4Sale]
[Hall of Fame]
[Rankings]
[Records]
[Teams]
[Players]
[NFL]
[Owners]
[Leagues]
[Help]
    
[ Football: Mr. Sports ]

Players of the WeekTrends Who's Hot Who's Not Yearly Stats
Best Weeks Best StreaksTop Performers Player Rankings Leaders
Draft Analysis Bye Weeks Injury Report NFL Rosters Search/Stats

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:/Websites/football.mrsports.com/natl/plyrdrft.cfm: line 68
Called from C:/Websites/football.mrsports.com/natl/plyrdrft.cfm: line 1
Called from C:/Websites/football.mrsports.com/natl/plyrdrft.cfm: line 68
Called from C:/Websites/football.mrsports.com/natl/plyrdrft.cfm: line 1
66 : 	<CFELSEIF sel_league is "One">
67 : 	and (drafts.league LIKE 'PL%' or drafts.league LIKE 'VL%' or drafts.league LIKE 'CL%' or drafts.league like 'BL%') 
68 : 	</CFIF> and leagues.league in (#quotedvaluelist(rundrafts.league)#) and leagues.league <> 'DL1'
69 : order by leagues.name asc
70 : </cFQUERY>

SQLSTATE   HY000
DATASOURCE   football
VENDORERRORCODE   102
SQL    select distinct drafts.league,leagues.league,leagues.name from drafts,leagues where drafts.year='2018' and drafts.league=leagues.league and leagues.league in () and leagues.league <> 'DL1' order by leagues.name asc
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.196.110.222
Referrer  
Date/Time   20-May-18 12:55 PM
Stack Trace
at cfplyrdrft2ecfm410008074._factor4(C:/Websites/football.mrsports.com/natl/plyrdrft.cfm:68) at cfplyrdrft2ecfm410008074.runPage(C:/Websites/football.mrsports.com/natl/plyrdrft.cfm:1) at cfplyrdrft2ecfm410008074._factor4(C:/Websites/football.mrsports.com/natl/plyrdrft.cfm:68) at cfplyrdrft2ecfm410008074.runPage(C:/Websites/football.mrsports.com/natl/plyrdrft.cfm:1)

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.dda3.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.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1451)
	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:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfplyrdrft2ecfm410008074._factor4(C:\Websites\football.mrsports.com\natl\plyrdrft.cfm:68)
	at cfplyrdrft2ecfm410008074.runPage(C:\Websites\football.mrsports.com\natl\plyrdrft.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:446)
	at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
	at coldfusion.filter.IpFilter.invoke(IpFilter.java:64)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:451)
	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.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	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:303)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	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:241)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:110)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:506)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:962)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:466)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:197)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:637)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)