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

Draft AnalysisWho's HotWho's NotLeaders Yearly StatsTop Performers
Pitching Probables Player Rankings Trends Injury Report MLB Rosters Search/Stats
Players of the Week QualifiersGames PlayedBest WeeksBest StreaksGames Per Week

Best Weeks

Wade Davis
Relief Pitcher
Colorado Rockies
Birthday: September 07, 1985   Age: 32
BreakdownPlayer Streaks OwnershipProtectableBest Weeks
StarterPlayer TrendsPlayer Rank Yearly SummaryBest Streaks
Draft AnalysisPlayer GraphTrade History Transaction History

*=Fireballer of the Week
RankScoreWeekProGamesPPGBreakdown

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]Column 'feeds.points' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.
 
The error occurred in C:/Websites/baseball.mrsports.com/natl/bestweeks.cfm: line 67
65 :          ppgR=(CONVERT(REAL,SUBSTRING(points,5,4)) / CONVERT(REAL,SUBSTRING(points,1,4))),description,feeds.period,proteam,hitplyr,pitplyr FROM feeds,weekly WHERE player = '#plyrinfo.player#' and feeds.period*=weekly.period
66 : <CFIF theyear neq "All">
67 : and feeds.period like '#theyear#%%'
68 : </CFIF>
69 : having CONVERT(REAL,SUBSTRING(points,1,4)) > 0

SQLSTATE   HY000
DATASOURCE   baseball
VENDORERRORCODE   8121
SQL    SELECT ptsR=CONVERT(INT,SUBSTRING(points,5,4)), gmsR=CONVERT(INT,SUBSTRING(points,1,4)), ppgR=(CONVERT(REAL,SUBSTRING(points,5,4)) / CONVERT(REAL,SUBSTRING(points,1,4))),description,feeds.period,proteam,hitplyr,pitplyr FROM feeds,weekly WHERE player = '8174 ' and feeds.period*=weekly.period having CONVERT(REAL,SUBSTRING(points,1,4)) > 0 order by ptsr desc,gmsr asc,feeds.period desc
Resources:

Browser   CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address   54.166.141.12
Referrer  
Date/Time   24-Jun-18 11:28 AM
Stack Trace
at cfbestweeks2ecfm1675608930.runPage(C:/Websites/baseball.mrsports.com/natl/bestweeks.cfm:67) at cfbestweeks2ecfm1675608930.runPage(C:/Websites/baseball.mrsports.com/natl/bestweeks.cfm:67)

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Column 'feeds.points' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.
	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 cfbestweeks2ecfm1675608930.runPage(C:\Websites\baseball.mrsports.com\natl\bestweeks.cfm:67)
	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)