Scope Arguments
exception1
Catch
Entries: 18
additional
Struct (ordered)
SQL
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4305
DriverName
stringMicrosoft JDBC Driver 12.6 for SQL Server
DriverVersion
string12.6.3.0
Datasource
stringbaseball
Cause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4305
DriverName
stringMicrosoft JDBC Driver 12.6 for SQL Server
DriverVersion
string12.6.3.0
Datasource
stringbaseball
DataSource
stringbaseball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringAn error occurred during the current command (Done status 0). Conversion failed when converting the varchar value 'A' to data type int.
NativeErrorCode
number245
queryError
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
Sql
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: An error occurred during the current command (Done status 0). Conversion failed when converting the varchar value 'A' to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5455) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:103) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5558) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1821) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1079) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:683) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:315) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at baseball.league.index_continuous_cfm270$cf.call(/baseball/league/index-continuous.cfm:22) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at baseball.league.index_cfm$cf.call(/baseball/league/index.cfm:35) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at application_cfc$cf.udfCall1_000085(/application.cfc:1110) at application_cfc$cf.udfCall1(/application.cfc:1107) at application_cfc$cf.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:738) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2123) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:479) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:214) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:128) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:165) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:77) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:113) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at mod_cfml.core.invoke(core.java:180) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:397) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1801) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:946) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:480) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:57) at java.base/java.lang.Thread.run(Thread.java:840)
TagContext
Array
1
Struct
codePrintHTML
string20: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 21: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;order&nbsp;by&nbsp;hfa&nbsp;desc<br> <b>22: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 23: &lt;cfelseif&nbsp;request.week&nbsp;eq&nbsp;&quot;00&quot;&gt;<br> 24: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfquery&nbsp;name=&quot;leaguehasplayers&quot;&nbsp;datasource=&quot;#datasource#&quot;&gt;<br>
codePrintPlain
string20: </cfif> 21: order by hfa desc 22: </cfquery> 23: <cfelseif request.week eq "00"> 24: <cfquery name="leaguehasplayers" datasource="#datasource#">
column
number0
id
string??
line
number22
Raw_Trace
stringbaseball.league.index_continuous_cfm270$cf.call(/baseball/league/index-continuous.cfm:22)
template
string/opt/lucee/tomcat/webapps/mrsports/baseball/league/index-continuous.cfm
type
stringcfml
2
Struct
codePrintHTML
string33: &lt;/cfsilent&gt;<br> 34: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif&nbsp;request.league_type&nbsp;eq&nbsp;1&gt;<br> <b>35: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;/baseball/league/index-continuous.cfm&quot;&gt;</b><br> 36: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfelseif&nbsp;request.league_type&nbsp;eq&nbsp;2&gt;<br> 37: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;/baseball/league/index-oneyear.cfm&quot;&gt;<br>
codePrintPlain
string33: </cfsilent> 34: <cfif request.league_type eq 1> 35: <cfinclude template="/baseball/league/index-continuous.cfm"> 36: <cfelseif request.league_type eq 2> 37: <cfinclude template="/baseball/league/index-oneyear.cfm">
column
number0
id
string??
line
number35
Raw_Trace
stringbaseball.league.index_cfm$cf.call(/baseball/league/index.cfm:35)
template
string/opt/lucee/tomcat/webapps/mrsports/baseball/league/index.cfm
type
stringcfml
3
Struct
codePrintHTML
string1108: <br> 1109: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Include&nbsp;the&nbsp;requested&nbsp;page.&nbsp;---&gt;<br> <b>1110: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#arguments.TargetPage#&quot;&nbsp;/&gt;</b><br> 1111: <br> 1112: &nbsp;&nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string1108: 1109: <!--- Include the requested page. ---> 1110: <cfinclude template="#arguments.TargetPage#" /> 1111: 1112: </cffunction>
column
number0
id
string??
line
number1110
Raw_Trace
stringapplication_cfc$cf.udfCall1_000085(/application.cfc:1110)
template
string/opt/lucee/tomcat/webapps/mrsports/application.cfc
type
stringcfml
4
Struct
codePrintHTML
string1105: <br> 1106: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Define&nbsp;arguments.&nbsp;---&gt;<br> <b>1107: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;targetPage&quot;&nbsp;type=&quot;String&quot;&nbsp;required=&quot;true&quot;&nbsp;/&gt;</b><br> 1108: <br> 1109: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Include&nbsp;the&nbsp;requested&nbsp;page.&nbsp;---&gt;<br>
codePrintPlain
string1105: 1106: <!--- Define arguments. ---> 1107: <cfargument name="targetPage" type="String" required="true" /> 1108: 1109: <!--- Include the requested page. --->
column
number0
id
string??
line
number1107
Raw_Trace
stringapplication_cfc$cf.udfCall1(/application.cfc:1107)
template
string/opt/lucee/tomcat/webapps/mrsports/application.cfc
type
stringcfml
type
stringdatabase
where
string
DataSource
stringbaseball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringAn error occurred during the current command (Done status 0). Conversion failed when converting the varchar value 'A' to data type int.
name
stringonRequest
NativeErrorCode
number245
queryError
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
rootCause
Struct
Entries: 15
additional
Struct (ordered)
SQL
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
DatabaseName
stringMicrosoft SQL Server
DatabaseVersion
string16.00.4305
DriverName
stringMicrosoft JDBC Driver 12.6 for SQL Server
DriverVersion
string12.6.3.0
Datasource
stringbaseball
DataSource
stringbaseball
Detail
string
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringAn error occurred during the current command (Done status 0). Conversion failed when converting the varchar value 'A' to data type int.
NativeErrorCode
number245
queryError
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
Sql
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: An error occurred during the current command (Done status 0). Conversion failed when converting the varchar value 'A' to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5455) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:103) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5558) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1821) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1079) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:683) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:315) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at baseball.league.index_continuous_cfm270$cf.call(/baseball/league/index-continuous.cfm:22) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at baseball.league.index_cfm$cf.call(/baseball/league/index.cfm:35) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at application_cfc$cf.udfCall1_000085(/application.cfc:1110) at application_cfc$cf.udfCall1(/application.cfc:1107) at application_cfc$cf.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:738) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2123) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:479) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:214) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:128) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:165) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:77) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:113) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at mod_cfml.core.invoke(core.java:180) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:397) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1801) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:946) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:480) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:57) at java.base/java.lang.Thread.run(Thread.java:840)
TagContext
Array
1
Struct
codePrintHTML
string20: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 21: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;order&nbsp;by&nbsp;hfa&nbsp;desc<br> <b>22: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 23: &lt;cfelseif&nbsp;request.week&nbsp;eq&nbsp;&quot;00&quot;&gt;<br> 24: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfquery&nbsp;name=&quot;leaguehasplayers&quot;&nbsp;datasource=&quot;#datasource#&quot;&gt;<br>
codePrintPlain
string20: </cfif> 21: order by hfa desc 22: </cfquery> 23: <cfelseif request.week eq "00"> 24: <cfquery name="leaguehasplayers" datasource="#datasource#">
column
number0
id
string??
line
number22
Raw_Trace
stringbaseball.league.index_continuous_cfm270$cf.call(/baseball/league/index-continuous.cfm:22)
template
string/opt/lucee/tomcat/webapps/mrsports/baseball/league/index-continuous.cfm
type
stringcfml
2
Struct
codePrintHTML
string33: &lt;/cfsilent&gt;<br> 34: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif&nbsp;request.league_type&nbsp;eq&nbsp;1&gt;<br> <b>35: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;/baseball/league/index-continuous.cfm&quot;&gt;</b><br> 36: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfelseif&nbsp;request.league_type&nbsp;eq&nbsp;2&gt;<br> 37: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;/baseball/league/index-oneyear.cfm&quot;&gt;<br>
codePrintPlain
string33: </cfsilent> 34: <cfif request.league_type eq 1> 35: <cfinclude template="/baseball/league/index-continuous.cfm"> 36: <cfelseif request.league_type eq 2> 37: <cfinclude template="/baseball/league/index-oneyear.cfm">
column
number0
id
string??
line
number35
Raw_Trace
stringbaseball.league.index_cfm$cf.call(/baseball/league/index.cfm:35)
template
string/opt/lucee/tomcat/webapps/mrsports/baseball/league/index.cfm
type
stringcfml
3
Struct
codePrintHTML
string1108: <br> 1109: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Include&nbsp;the&nbsp;requested&nbsp;page.&nbsp;---&gt;<br> <b>1110: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#arguments.TargetPage#&quot;&nbsp;/&gt;</b><br> 1111: <br> 1112: &nbsp;&nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string1108: 1109: <!--- Include the requested page. ---> 1110: <cfinclude template="#arguments.TargetPage#" /> 1111: 1112: </cffunction>
column
number0
id
string??
line
number1110
Raw_Trace
stringapplication_cfc$cf.udfCall1_000085(/application.cfc:1110)
template
string/opt/lucee/tomcat/webapps/mrsports/application.cfc
type
stringcfml
4
Struct
codePrintHTML
string1105: <br> 1106: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Define&nbsp;arguments.&nbsp;---&gt;<br> <b>1107: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;targetPage&quot;&nbsp;type=&quot;String&quot;&nbsp;required=&quot;true&quot;&nbsp;/&gt;</b><br> 1108: <br> 1109: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Include&nbsp;the&nbsp;requested&nbsp;page.&nbsp;---&gt;<br>
codePrintPlain
string1105: 1106: <!--- Define arguments. ---> 1107: <cfargument name="targetPage" type="String" required="true" /> 1108: 1109: <!--- Include the requested page. --->
column
number0
id
string??
line
number1107
Raw_Trace
stringapplication_cfc$cf.udfCall1(/application.cfc:1107)
template
string/opt/lucee/tomcat/webapps/mrsports/application.cfc
type
stringcfml
type
stringdatabase
where
string
Sql
stringSELECT distinct games.team,op1,op2,op3,tm.name,opone.name as oponename, hfa FROM games inner join teams as tm on games.team=tm.team left outer join teams as opone on opone.team=op1 WHERE games.league = 'EL14' AND games.division in (1,2) order by hfa desc
SQLState
stringS0001
StackTrace
stringlucee.runtime.exp.DatabaseException: An error occurred during the current command (Done status 0). Conversion failed when converting the varchar value 'A' to data type int. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:261) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer$FetchBufferTokenHandler.onDone(SQLServerResultSet.java:5455) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:103) at com.microsoft.sqlserver.jdbc.TDSParser.parse(tdsparser.java:42) at com.microsoft.sqlserver.jdbc.SQLServerResultSet$FetchBuffer.nextRow(SQLServerResultSet.java:5558) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.fetchBufferNext(SQLServerResultSet.java:1821) at com.microsoft.sqlserver.jdbc.SQLServerResultSet.next(SQLServerResultSet.java:1079) at lucee.runtime.type.QueryImpl.fillResult(QueryImpl.java:683) at lucee.runtime.type.QueryImpl.execute(QueryImpl.java:315) at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:244) at lucee.runtime.tag.Query.executeDatasoure(Query.java:1125) at lucee.runtime.tag.Query._doEndTag(Query.java:692) at lucee.runtime.tag.Query.doEndTag(Query.java:557) at baseball.league.index_continuous_cfm270$cf.call(/baseball/league/index-continuous.cfm:22) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at baseball.league.index_cfm$cf.call(/baseball/league/index.cfm:35) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1118) at lucee.runtime.PageContextImpl._doInclude(PageContextImpl.java:1012) at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:993) at application_cfc$cf.udfCall1_000085(/application.cfc:1110) at application_cfc$cf.udfCall1(/application.cfc:1107) at application_cfc$cf.udfCall(/application.cfc) at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112) at lucee.runtime.type.UDFImpl._call(UDFImpl.java:357) at lucee.runtime.type.UDFImpl.call(UDFImpl.java:224) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:738) at lucee.runtime.ComponentImpl._call(ComponentImpl.java:611) at lucee.runtime.ComponentImpl.call(ComponentImpl.java:2123) at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:479) at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:214) at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:43) at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2816) at lucee.runtime.PageContextImpl._execute(PageContextImpl.java:2803) at lucee.runtime.PageContextImpl.executeCFML(PageContextImpl.java:2774) at lucee.runtime.engine.Request.exe(Request.java:45) at lucee.runtime.engine.CFMLEngineImpl._service(CFMLEngineImpl.java:1113) at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:1070) at lucee.loader.engine.CFMLEngineWrapper.serviceCFML(CFMLEngineWrapper.java:97) at lucee.loader.servlet.jakarta.CFMLServlet.service(CFMLServlet.java:52) at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:710) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:128) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:107) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:165) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:77) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:492) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:113) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:83) at mod_cfml.core.invoke(core.java:180) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:72) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:341) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:397) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:903) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1801) at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52) at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:946) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:480) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:57) at java.base/java.lang.Thread.run(Thread.java:840)
TagContext
Array
1
Struct
codePrintHTML
string20: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfif&gt;<br> 21: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;order&nbsp;by&nbsp;hfa&nbsp;desc<br> <b>22: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;/cfquery&gt;</b><br> 23: &lt;cfelseif&nbsp;request.week&nbsp;eq&nbsp;&quot;00&quot;&gt;<br> 24: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfquery&nbsp;name=&quot;leaguehasplayers&quot;&nbsp;datasource=&quot;#datasource#&quot;&gt;<br>
codePrintPlain
string20: </cfif> 21: order by hfa desc 22: </cfquery> 23: <cfelseif request.week eq "00"> 24: <cfquery name="leaguehasplayers" datasource="#datasource#">
column
number0
id
string??
line
number22
Raw_Trace
stringbaseball.league.index_continuous_cfm270$cf.call(/baseball/league/index-continuous.cfm:22)
template
string/opt/lucee/tomcat/webapps/mrsports/baseball/league/index-continuous.cfm
type
stringcfml
2
Struct
codePrintHTML
string33: &lt;/cfsilent&gt;<br> 34: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfif&nbsp;request.league_type&nbsp;eq&nbsp;1&gt;<br> <b>35: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;/baseball/league/index-continuous.cfm&quot;&gt;</b><br> 36: &nbsp;&nbsp;&nbsp;&nbsp;&lt;cfelseif&nbsp;request.league_type&nbsp;eq&nbsp;2&gt;<br> 37: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;/baseball/league/index-oneyear.cfm&quot;&gt;<br>
codePrintPlain
string33: </cfsilent> 34: <cfif request.league_type eq 1> 35: <cfinclude template="/baseball/league/index-continuous.cfm"> 36: <cfelseif request.league_type eq 2> 37: <cfinclude template="/baseball/league/index-oneyear.cfm">
column
number0
id
string??
line
number35
Raw_Trace
stringbaseball.league.index_cfm$cf.call(/baseball/league/index.cfm:35)
template
string/opt/lucee/tomcat/webapps/mrsports/baseball/league/index.cfm
type
stringcfml
3
Struct
codePrintHTML
string1108: <br> 1109: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Include&nbsp;the&nbsp;requested&nbsp;page.&nbsp;---&gt;<br> <b>1110: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfinclude&nbsp;template=&quot;#arguments.TargetPage#&quot;&nbsp;/&gt;</b><br> 1111: <br> 1112: &nbsp;&nbsp;&nbsp;&nbsp;&lt;/cffunction&gt;<br>
codePrintPlain
string1108: 1109: <!--- Include the requested page. ---> 1110: <cfinclude template="#arguments.TargetPage#" /> 1111: 1112: </cffunction>
column
number0
id
string??
line
number1110
Raw_Trace
stringapplication_cfc$cf.udfCall1_000085(/application.cfc:1110)
template
string/opt/lucee/tomcat/webapps/mrsports/application.cfc
type
stringcfml
4
Struct
codePrintHTML
string1105: <br> 1106: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Define&nbsp;arguments.&nbsp;---&gt;<br> <b>1107: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;cfargument&nbsp;name=&quot;targetPage&quot;&nbsp;type=&quot;String&quot;&nbsp;required=&quot;true&quot;&nbsp;/&gt;</b><br> 1108: <br> 1109: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&lt;!---&nbsp;Include&nbsp;the&nbsp;requested&nbsp;page.&nbsp;---&gt;<br>
codePrintPlain
string1105: 1106: <!--- Define arguments. ---> 1107: <cfargument name="targetPage" type="String" required="true" /> 1108: 1109: <!--- Include the requested page. --->
column
number0
id
string??
line
number1107
Raw_Trace
stringapplication_cfc$cf.udfCall1(/application.cfc:1107)
template
string/opt/lucee/tomcat/webapps/mrsports/application.cfc
type
stringcfml
type
stringdatabase
where
string
eventName2
stringonRequest