cannot cast [clear] string to a number value
Catch
Entries: 13
additional
Struct
cause
Struct
additional
Struct
Detail
string
ErrNumber
number0
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringcannot cast [clear] string to a number value
StackTrace
stringcannot cast [clear] string to a number value at lucee.runtime.op.Caster.toDoubleValue(Caster.java:518):518 at lucee.runtime.op.Caster.toIntValue(Caster.java:785):785 at lucee.runtime.op.Caster.toIntValue(Caster.java:742):742 at lucee.runtime.op.Caster.toInteger(Caster.java:4092):4092 at lucee.runtime.db.SQLCaster.setValue(SQLCaster.java:276):276 at lucee.runtime.type.QueryImpl.setItems(QueryImpl.java:358):358 at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:252):252 at lucee.runtime.tag.Query.executeDatasoure(Query.java:815):815 at lucee.runtime.tag.Query.doEndTag(Query.java:610):610 at product.index_cfm$cf.call(/product/index.cfm:7):7 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:959):959 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:863):863 at application_cfc$cf.udfCall(/Application.cfc:51):51 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414 at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2276):2276 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2239):2239 at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:460):460 at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731):731 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at com.seefusion.Filter.doFilter(Filter.java:49):49 at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500):1500 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218):218 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505):505 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169):169 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103):103 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442):442 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190):190 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:623):623 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316):316 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149):1149 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624):624 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61 at java.lang.Thread.run(Thread.java:748):748
TagContext
Array
1
Struct
codePrintHTML
string5: FROM tbl_prods<br> 6: WHERE prodID = &lt;cfqueryparam cfsqltype=&quot;cf_sql_integer&quot; value=&quot;#ListLast(URL.q1, &quot;-&quot;)#&quot; /&gt;<br> <b>7: &lt;/cfquery&gt;</b><br> 8: &lt;!--- REDIRECT IF PRODUCT NOT FOUND ---&gt;<br> 9: &lt;cfif rsProd.RecordCount EQ 0&gt;<br>
codePrintPlain
string5: FROM tbl_prods 6: WHERE prodID = <cfqueryparam cfsqltype="cf_sql_integer" value="#ListLast(URL.q1, "-")#" /> 7: </cfquery> 8: <!--- REDIRECT IF PRODUCT NOT FOUND ---> 9: <cfif rsProd.RecordCount EQ 0>
column
number0
id
string??
line
number7
Raw_Trace
stringproduct.index_cfm$cf.call(/product/index.cfm:7)
template
stringD:\home\unlimitedappliances.com\wwwroot\product\index.cfm
type
stringcfml
2
Struct
codePrintHTML
string49: <br> 50: &lt;cfsavecontent variable=&quot;myPage&quot;&gt;<br> <b>51: &lt;cfinclude template=&quot;#arguments.thePage#&quot; /&gt;</b><br> 52: &lt;/cfsavecontent&gt;<br> 53: <br>
codePrintPlain
string49: 50: <cfsavecontent variable="myPage"> 51: <cfinclude template="#arguments.thePage#" /> 52: </cfsavecontent> 53:
column
number0
id
string??
line
number51
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:51)
template
stringD:\home\unlimitedappliances.com\wwwroot\application.cfc
type
stringcfml
type
stringexpression
Detail
string
ErrNumber
number0
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringcannot cast [clear] string to a number value
name
stringonRequest
rootCause
Struct
additional
Struct
Detail
string
ErrNumber
number0
ErrorCode
string0
Extended_Info
string
ExtendedInfo
string
Message
stringcannot cast [clear] string to a number value
StackTrace
stringcannot cast [clear] string to a number value at lucee.runtime.op.Caster.toDoubleValue(Caster.java:518):518 at lucee.runtime.op.Caster.toIntValue(Caster.java:785):785 at lucee.runtime.op.Caster.toIntValue(Caster.java:742):742 at lucee.runtime.op.Caster.toInteger(Caster.java:4092):4092 at lucee.runtime.db.SQLCaster.setValue(SQLCaster.java:276):276 at lucee.runtime.type.QueryImpl.setItems(QueryImpl.java:358):358 at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:252):252 at lucee.runtime.tag.Query.executeDatasoure(Query.java:815):815 at lucee.runtime.tag.Query.doEndTag(Query.java:610):610 at product.index_cfm$cf.call(/product/index.cfm:7):7 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:959):959 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:863):863 at application_cfc$cf.udfCall(/Application.cfc:51):51 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414 at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2276):2276 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2239):2239 at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:460):460 at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731):731 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at com.seefusion.Filter.doFilter(Filter.java:49):49 at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500):1500 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218):218 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505):505 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169):169 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103):103 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442):442 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190):190 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:623):623 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316):316 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149):1149 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624):624 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61 at java.lang.Thread.run(Thread.java:748):748
TagContext
Array
1
Struct
codePrintHTML
string5: FROM tbl_prods<br> 6: WHERE prodID = &lt;cfqueryparam cfsqltype=&quot;cf_sql_integer&quot; value=&quot;#ListLast(URL.q1, &quot;-&quot;)#&quot; /&gt;<br> <b>7: &lt;/cfquery&gt;</b><br> 8: &lt;!--- REDIRECT IF PRODUCT NOT FOUND ---&gt;<br> 9: &lt;cfif rsProd.RecordCount EQ 0&gt;<br>
codePrintPlain
string5: FROM tbl_prods 6: WHERE prodID = <cfqueryparam cfsqltype="cf_sql_integer" value="#ListLast(URL.q1, "-")#" /> 7: </cfquery> 8: <!--- REDIRECT IF PRODUCT NOT FOUND ---> 9: <cfif rsProd.RecordCount EQ 0>
column
number0
id
string??
line
number7
Raw_Trace
stringproduct.index_cfm$cf.call(/product/index.cfm:7)
template
stringD:\home\unlimitedappliances.com\wwwroot\product\index.cfm
type
stringcfml
2
Struct
codePrintHTML
string49: <br> 50: &lt;cfsavecontent variable=&quot;myPage&quot;&gt;<br> <b>51: &lt;cfinclude template=&quot;#arguments.thePage#&quot; /&gt;</b><br> 52: &lt;/cfsavecontent&gt;<br> 53: <br>
codePrintPlain
string49: 50: <cfsavecontent variable="myPage"> 51: <cfinclude template="#arguments.thePage#" /> 52: </cfsavecontent> 53:
column
number0
id
string??
line
number51
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:51)
template
stringD:\home\unlimitedappliances.com\wwwroot\application.cfc
type
stringcfml
type
stringexpression
StackTrace
stringcannot cast [clear] string to a number value at lucee.runtime.op.Caster.toDoubleValue(Caster.java:518):518 at lucee.runtime.op.Caster.toIntValue(Caster.java:785):785 at lucee.runtime.op.Caster.toIntValue(Caster.java:742):742 at lucee.runtime.op.Caster.toInteger(Caster.java:4092):4092 at lucee.runtime.db.SQLCaster.setValue(SQLCaster.java:276):276 at lucee.runtime.type.QueryImpl.setItems(QueryImpl.java:358):358 at lucee.runtime.type.QueryImpl.<init>(QueryImpl.java:252):252 at lucee.runtime.tag.Query.executeDatasoure(Query.java:815):815 at lucee.runtime.tag.Query.doEndTag(Query.java:610):610 at product.index_cfm$cf.call(/product/index.cfm:7):7 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:959):959 at lucee.runtime.PageContextImpl.doInclude(PageContextImpl.java:863):863 at application_cfc$cf.udfCall(/Application.cfc:51):51 at lucee.runtime.type.UDFImpl.implementation(UDFImpl.java:112):112 at lucee.runtime.type.UDFImpl._call(UDFImpl.java:329):329 at lucee.runtime.type.UDFImpl.call(UDFImpl.java:230):230 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:642):642 at lucee.runtime.ComponentImpl._call(ComponentImpl.java:524):524 at lucee.runtime.ComponentImpl.call(ComponentImpl.java:1763):1763 at lucee.runtime.listener.ModernAppListener.call(ModernAppListener.java:414):414 at lucee.runtime.listener.ModernAppListener._onRequest(ModernAppListener.java:223):223 at lucee.runtime.listener.MixedAppListener.onRequest(MixedAppListener.java:37):37 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2276):2276 at lucee.runtime.PageContextImpl.execute(PageContextImpl.java:2239):2239 at lucee.runtime.engine.CFMLEngineImpl.serviceCFML(CFMLEngineImpl.java:460):460 at lucee.loader.servlet.CFMLServlet.service(CFMLServlet.java:47):47 at javax.servlet.http.HttpServlet.service(HttpServlet.java:731):731 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303):303 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52):52 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at com.seefusion.Filter.doFilter(Filter.java:49):49 at com.seefusion.SeeFusion.doFilter(SeeFusion.java:1500):1500 at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:241):241 at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208):208 at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:218):218 at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122):122 at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:505):505 at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:169):169 at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103):103 at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116):116 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:442):442 at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:190):190 at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:623):623 at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:316):316 at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149):1149 at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624):624 at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61):61 at java.lang.Thread.run(Thread.java:748):748
TagContext
Array
1
Struct
codePrintHTML
string5: FROM tbl_prods<br> 6: WHERE prodID = &lt;cfqueryparam cfsqltype=&quot;cf_sql_integer&quot; value=&quot;#ListLast(URL.q1, &quot;-&quot;)#&quot; /&gt;<br> <b>7: &lt;/cfquery&gt;</b><br> 8: &lt;!--- REDIRECT IF PRODUCT NOT FOUND ---&gt;<br> 9: &lt;cfif rsProd.RecordCount EQ 0&gt;<br>
codePrintPlain
string5: FROM tbl_prods 6: WHERE prodID = <cfqueryparam cfsqltype="cf_sql_integer" value="#ListLast(URL.q1, "-")#" /> 7: </cfquery> 8: <!--- REDIRECT IF PRODUCT NOT FOUND ---> 9: <cfif rsProd.RecordCount EQ 0>
column
number0
id
string??
line
number7
Raw_Trace
stringproduct.index_cfm$cf.call(/product/index.cfm:7)
template
stringD:\home\unlimitedappliances.com\wwwroot\product\index.cfm
type
stringcfml
2
Struct
codePrintHTML
string49: <br> 50: &lt;cfsavecontent variable=&quot;myPage&quot;&gt;<br> <b>51: &lt;cfinclude template=&quot;#arguments.thePage#&quot; /&gt;</b><br> 52: &lt;/cfsavecontent&gt;<br> 53: <br>
codePrintPlain
string49: 50: <cfsavecontent variable="myPage"> 51: <cfinclude template="#arguments.thePage#" /> 52: </cfsavecontent> 53:
column
number0
id
string??
line
number51
Raw_Trace
stringapplication_cfc$cf.udfCall(/Application.cfc:51)
template
stringD:\home\unlimitedappliances.com\wwwroot\application.cfc
type
stringcfml
type
stringexpression