| exception | 1 | Catch
Entries: 18 | | additional | | Struct (ordered) | | SQL | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.2 for SQL Server |
| | DriverVersion | | | Datasource | |
| | Cause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.2 for SQL Server |
| | DriverVersion | | | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | Incorrect syntax near the keyword 'and'. |
| | NativeErrorCode | | | queryError | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | Sql | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: Incorrect syntax near the keyword 'and'.
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 baseball.league.owner_all_time_standings_cfm1395$cf$7px.call(/baseball/league/owner-all-time-standings.cfm:37)
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$5yv.udfCall1(/application.cfc:792)
at application_cfc$cf$5yv.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 | | string | 35: <cfquery name="owneralltimestandings" datasource="#datasource#"><br>
36: select<br>
<b>37: first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='#request.league#' and ownerstandings.owner <> 164 and ownerstandings.year between #thestartyear# and #theendyear# and first <> 'Unowned'</b><br>
38: group by ownerstandings.owner,first,last<br>
39: order by winpct desc,totavg desc,thewins desc<br>
|
| | codePrintPlain | | string | 35: <cfquery name="owneralltimestandings" datasource="#datasource#">
36: select
37: first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='#request.league#' and ownerstandings.owner <> 164 and ownerstandings.year between #thestartyear# and #theendyear# and first <> 'Unowned'
38: group by ownerstandings.owner,first,last
39: order by winpct desc,totavg desc,thewins desc
|
| | column | | | id | | | line | | | Raw_Trace | | string | baseball.league.owner_all_time_standings_cfm1395$cf$7px.call(/baseball/league/owner-all-time-standings.cfm:37) |
| | template | | string | C:\Websites\www.mrsports.com\baseball\league\owner-all-time-standings.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 790: <br>
791: <!--- Include the requested page. ---><br>
<b>792: <cfinclude template="#arguments.TargetPage#" /></b><br>
793: <br>
794: </cffunction><br>
|
| | codePrintPlain | | string | 790:
791: <!--- Include the requested page. --->
792: <cfinclude template="#arguments.TargetPage#" />
793:
794: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf$5yv.udfCall1(/application.cfc:792) |
| | template | | string | C:\Websites\www.mrsports.com\application.cfc |
| | type | |
|
| | type | | | where | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | Incorrect syntax near the keyword 'and'. |
| | name | | | NativeErrorCode | | | queryError | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | rootCause | Struct
Entries: 15 | | additional | | Struct (ordered) | | SQL | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | DatabaseName | | string | Microsoft SQL Server |
| | DatabaseVersion | | | DriverName | | string | Microsoft JDBC Driver 12.2 for SQL Server |
| | DriverVersion | | | Datasource | |
| | DataSource | | | Detail | | | ErrorCode | | | Extended_Info | | | ExtendedInfo | | | Message | | string | Incorrect syntax near the keyword 'and'. |
| | NativeErrorCode | | | queryError | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | Sql | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: Incorrect syntax near the keyword 'and'.
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 baseball.league.owner_all_time_standings_cfm1395$cf$7px.call(/baseball/league/owner-all-time-standings.cfm:37)
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$5yv.udfCall1(/application.cfc:792)
at application_cfc$cf$5yv.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 | | string | 35: <cfquery name="owneralltimestandings" datasource="#datasource#"><br>
36: select<br>
<b>37: first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='#request.league#' and ownerstandings.owner <> 164 and ownerstandings.year between #thestartyear# and #theendyear# and first <> 'Unowned'</b><br>
38: group by ownerstandings.owner,first,last<br>
39: order by winpct desc,totavg desc,thewins desc<br>
|
| | codePrintPlain | | string | 35: <cfquery name="owneralltimestandings" datasource="#datasource#">
36: select
37: first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='#request.league#' and ownerstandings.owner <> 164 and ownerstandings.year between #thestartyear# and #theendyear# and first <> 'Unowned'
38: group by ownerstandings.owner,first,last
39: order by winpct desc,totavg desc,thewins desc
|
| | column | | | id | | | line | | | Raw_Trace | | string | baseball.league.owner_all_time_standings_cfm1395$cf$7px.call(/baseball/league/owner-all-time-standings.cfm:37) |
| | template | | string | C:\Websites\www.mrsports.com\baseball\league\owner-all-time-standings.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 790: <br>
791: <!--- Include the requested page. ---><br>
<b>792: <cfinclude template="#arguments.TargetPage#" /></b><br>
793: <br>
794: </cffunction><br>
|
| | codePrintPlain | | string | 790:
791: <!--- Include the requested page. --->
792: <cfinclude template="#arguments.TargetPage#" />
793:
794: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf$5yv.udfCall1(/application.cfc:792) |
| | template | | string | C:\Websites\www.mrsports.com\application.cfc |
| | type | |
|
| | type | | | where | |
| | Sql | | string | select
first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='' and ownerstandings.owner <> 164 and ownerstandings.year between and and first <> 'Unowned'
group by ownerstandings.owner,first,last
order by winpct desc,totavg desc,thewins desc |
| | SQLState | | | StackTrace | | string | lucee.runtime.exp.DatabaseException: Incorrect syntax near the keyword 'and'.
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 baseball.league.owner_all_time_standings_cfm1395$cf$7px.call(/baseball/league/owner-all-time-standings.cfm:37)
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$5yv.udfCall1(/application.cfc:792)
at application_cfc$cf$5yv.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 | | string | 35: <cfquery name="owneralltimestandings" datasource="#datasource#"><br>
36: select<br>
<b>37: first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='#request.league#' and ownerstandings.owner <> 164 and ownerstandings.year between #thestartyear# and #theendyear# and first <> 'Unowned'</b><br>
38: group by ownerstandings.owner,first,last<br>
39: order by winpct desc,totavg desc,thewins desc<br>
|
| | codePrintPlain | | string | 35: <cfquery name="owneralltimestandings" datasource="#datasource#">
36: select
37: first,last,thewins=sum(wins),theloses=sum(loses),thehitpoints=sum(hitpoints),thepitpoints=sum(pitpoints),thetotpoints=sum(totpoints),thehithigh=max(hithigh),thepithigh=max(pithigh),thetothigh=max(tothigh),theeastwin=sum(eastwin),theeastlose=sum(eastlose),thecentwin=sum(centwin),thecentlose=sum(centlose),thewestwin=sum(westwin),thewestlose=sum(westlose),thenumofweeks=sum(numofweeks),ownerstandings.owner,winpct=(convert(real,sum(wins))/(convert(real,sum(loses))+convert(real,sum(wins)))),totavg=convert(real,sum(totpoints))/convert(real,sum(numofweeks)) from teams,ownerstandings,owners where teams.league=ownerstandings.league and teams.team=ownerstandings.team and owners.owner=ownerstandings.owner and ownerstandings.league='#request.league#' and ownerstandings.owner <> 164 and ownerstandings.year between #thestartyear# and #theendyear# and first <> 'Unowned'
38: group by ownerstandings.owner,first,last
39: order by winpct desc,totavg desc,thewins desc
|
| | column | | | id | | | line | | | Raw_Trace | | string | baseball.league.owner_all_time_standings_cfm1395$cf$7px.call(/baseball/league/owner-all-time-standings.cfm:37) |
| | template | | string | C:\Websites\www.mrsports.com\baseball\league\owner-all-time-standings.cfm |
| | type | |
| | 2 | | Struct | | codePrintHTML | | string | 790: <br>
791: <!--- Include the requested page. ---><br>
<b>792: <cfinclude template="#arguments.TargetPage#" /></b><br>
793: <br>
794: </cffunction><br>
|
| | codePrintPlain | | string | 790:
791: <!--- Include the requested page. --->
792: <cfinclude template="#arguments.TargetPage#" />
793:
794: </cffunction>
|
| | column | | | id | | | line | | | Raw_Trace | | string | application_cfc$cf$5yv.udfCall1(/application.cfc:792) |
| | template | | string | C:\Websites\www.mrsports.com\application.cfc |
| | type | |
|
| | type | | | where | |
|