Standings thru Week 13, 2024

x= conference winner    y= playoff berth    z= eliminated

Eastern ConferenceAverageHighRecords
Team W L Win% GB Center Forward Guard Total Game vs East vs West
Western ConferenceAverageHighRecords
Team W L Win% GB Center Forward Guard Total Game vs East vs West
Wildcard StandingsAverageHighRecords
Team W L Win% GB Center Forward Guard Total Game vs East vs West
Scope Arguments
exception1
Catch
Entries: 18
additional
Struct (ordered)
SQL
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.7507
DriverName
stringMicrosoft JDBC Driver 12.2 for SQL Server
DriverVersion
string12.2.0.0
Datasource
stringbsktball
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.7507
DriverName
stringMicrosoft JDBC Driver 12.2 for SQL Server
DriverVersion
string12.2.0.0
Datasource
stringbsktball
DataSource
stringbsktball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near ')'.
NativeErrorCode
number102
queryError
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
Sql
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:920) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:814) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:787) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at basketball.league.standing_wildcard_cfm405$cf$6rc.call(/basketball/league/standing-wildcard.cfm:24) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at basketball.league.standings_cfm$cf$6r9.call(/basketball/league/standings.cfm:211) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application_cfc$cf$7.udfCall1(/application.cfc:806) at application_cfc$cf$7.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string22: ORDER BY<br> 23: won DESC, tot DESC<br> <b>24: &lt;/cfquery&gt;</b><br> 25: &lt;/cfsilent&gt;<br> 26: <br>
codePrintPlain
string22: ORDER BY 23: won DESC, tot DESC 24: </cfquery> 25: </cfsilent> 26:
column
number0
id
string??
line
number24
Raw_Trace
stringbasketball.league.standing_wildcard_cfm405$cf$6rc.call(/basketball/league/standing-wildcard.cfm:24)
template
stringC:\Websites\www.mrsports.com\basketball\league\standing-wildcard.cfm
type
stringcfml
2
Struct
codePrintHTML
string209: &lt;/tr&gt;<br> 210: &lt;/thead&gt;<br> <b>211: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 212: &lt;/table&gt;<br> 213: &lt;/cfif&gt;<br>
codePrintPlain
string209: </tr> 210: </thead> 211: <cfinclude template="standing-wildcard.cfm"> 212: </table> 213: </cfif>
column
number0
id
string??
line
number211
Raw_Trace
stringbasketball.league.standings_cfm$cf$6r9.call(/basketball/league/standings.cfm:211)
template
stringC:\Websites\www.mrsports.com\basketball\league\standings.cfm
type
stringcfml
3
Struct
codePrintHTML
string804: <br> 805: &lt;!--- Include the requested page. ---&gt;<br> <b>806: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 807: <br> 808: &lt;/cffunction&gt;<br>
codePrintPlain
string804: 805: <!--- Include the requested page. ---> 806: <cfinclude template="#arguments.TargetPage#" /> 807: 808: </cffunction>
column
number0
id
string??
line
number806
Raw_Trace
stringapplication_cfc$cf$7.udfCall1(/application.cfc:806)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
stringbsktball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near ')'.
name
stringonRequest
NativeErrorCode
number102
queryError
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
rootCause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string11.00.7507
DriverName
stringMicrosoft JDBC Driver 12.2 for SQL Server
DriverVersion
string12.2.0.0
Datasource
stringbsktball
DataSource
stringbsktball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringIncorrect syntax near ')'.
NativeErrorCode
number102
queryError
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
Sql
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:920) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:814) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:787) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at basketball.league.standing_wildcard_cfm405$cf$6rc.call(/basketball/league/standing-wildcard.cfm:24) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at basketball.league.standings_cfm$cf$6r9.call(/basketball/league/standings.cfm:211) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application_cfc$cf$7.udfCall1(/application.cfc:806) at application_cfc$cf$7.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string22: ORDER BY<br> 23: won DESC, tot DESC<br> <b>24: &lt;/cfquery&gt;</b><br> 25: &lt;/cfsilent&gt;<br> 26: <br>
codePrintPlain
string22: ORDER BY 23: won DESC, tot DESC 24: </cfquery> 25: </cfsilent> 26:
column
number0
id
string??
line
number24
Raw_Trace
stringbasketball.league.standing_wildcard_cfm405$cf$6rc.call(/basketball/league/standing-wildcard.cfm:24)
template
stringC:\Websites\www.mrsports.com\basketball\league\standing-wildcard.cfm
type
stringcfml
2
Struct
codePrintHTML
string209: &lt;/tr&gt;<br> 210: &lt;/thead&gt;<br> <b>211: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 212: &lt;/table&gt;<br> 213: &lt;/cfif&gt;<br>
codePrintPlain
string209: </tr> 210: </thead> 211: <cfinclude template="standing-wildcard.cfm"> 212: </table> 213: </cfif>
column
number0
id
string??
line
number211
Raw_Trace
stringbasketball.league.standings_cfm$cf$6r9.call(/basketball/league/standings.cfm:211)
template
stringC:\Websites\www.mrsports.com\basketball\league\standings.cfm
type
stringcfml
3
Struct
codePrintHTML
string804: <br> 805: &lt;!--- Include the requested page. ---&gt;<br> <b>806: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 807: <br> 808: &lt;/cffunction&gt;<br>
codePrintPlain
string804: 805: <!--- Include the requested page. ---> 806: <cfinclude template="#arguments.TargetPage#" /> 807: 808: </cffunction>
column
number0
id
string??
line
number806
Raw_Trace
stringapplication_cfc$cf$7.udfCall1(/application.cfc:806)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringSELECT games.team, won=isnull(SUM(won),0), loss=isnull(SUM(loss),0), eastwon=isnull(SUM(east_won),0), eastloss=isnull(SUM(east_loss),0), westwon=isnull(SUM(west_won),0), westloss=isnull(SUM(west_loss),0), tot=isnull(SUM(total_points),0), maxpts=isnull(max(total_points),0), centertot=isnull(sum(center_points),0), guardtot=isnull(sum(guard_points),0), forwardtot=isnull(sum(forward_points),0),teams.name FROM games inner join teams on games.team=teams.team WHERE games.league = '' and games.team in (select team from games where period='202400' and games.league='' and team not in (select team from games where period='202413' and (division='Z' or alivewild=1)) and team not in ()) AND period BETWEEN '202401' AND '202413' GROUP BY games.team,teams.name ORDER BY won DESC, tot DESC
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: Incorrect syntax near ')'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:265) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1695) at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(SQLServerStatement.java:920) at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(SQLServerStatement.java:814) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7685) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:4048) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:272) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:246) at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(SQLServerStatement.java:787) at lucee.runtime.type.util.QueryUtil.execute(QueryUtil.java:320) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:287) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:235) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1135) at lucee.runtime.tag.Query._doEndTag(Query.java:700) at lucee.runtime.tag.Query.doEndTag(Query.java:566) at basketball.league.standing_wildcard_cfm405$cf$6rc.call(/basketball/league/standing-wildcard.cfm:24) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at basketball.league.standings_cfm$cf$6r9.call(/basketball/league/standings.cfm:211) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1025) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:948) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:929) at application_cfc$cf$7.udfCall1(/application.cfc:806) at application_cfc$cf$7.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:350) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:223) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:664) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:586) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1933) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:444) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:218) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:44) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2493) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2478) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2449) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1216) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1162) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:623) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:209) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:178) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:153) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:481) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:130) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343) at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:422) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:926) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1791) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.base/java.lang.Thread.run(Unknown Source)
TagContext
Array
1
Struct
codePrintHTML
string22: ORDER BY<br> 23: won DESC, tot DESC<br> <b>24: &lt;/cfquery&gt;</b><br> 25: &lt;/cfsilent&gt;<br> 26: <br>
codePrintPlain
string22: ORDER BY 23: won DESC, tot DESC 24: </cfquery> 25: </cfsilent> 26:
column
number0
id
string??
line
number24
Raw_Trace
stringbasketball.league.standing_wildcard_cfm405$cf$6rc.call(/basketball/league/standing-wildcard.cfm:24)
template
stringC:\Websites\www.mrsports.com\basketball\league\standing-wildcard.cfm
type
stringcfml
2
Struct
codePrintHTML
string209: &lt;/tr&gt;<br> 210: &lt;/thead&gt;<br> <b>211: &lt;cfinclude template=&quot;standing-wildcard.cfm&quot;&gt;</b><br> 212: &lt;/table&gt;<br> 213: &lt;/cfif&gt;<br>
codePrintPlain
string209: </tr> 210: </thead> 211: <cfinclude template="standing-wildcard.cfm"> 212: </table> 213: </cfif>
column
number0
id
string??
line
number211
Raw_Trace
stringbasketball.league.standings_cfm$cf$6r9.call(/basketball/league/standings.cfm:211)
template
stringC:\Websites\www.mrsports.com\basketball\league\standings.cfm
type
stringcfml
3
Struct
codePrintHTML
string804: <br> 805: &lt;!--- Include the requested page. ---&gt;<br> <b>806: &lt;cfinclude template=&quot;#arguments.TargetPage#&quot; /&gt;</b><br> 807: <br> 808: &lt;/cffunction&gt;<br>
codePrintPlain
string804: 805: <!--- Include the requested page. ---> 806: <cfinclude template="#arguments.TargetPage#" /> 807: 808: </cffunction>
column
number0
id
string??
line
number806
Raw_Trace
stringapplication_cfc$cf$7.udfCall1(/application.cfc:806)
template
stringC:\Websites\www.mrsports.com\application.cfc
type
stringcfml
type
stringdatabase
where
string
eventName2
stringonRequest