Error Occurred While Processing Request The web site you are accessing has experienced an unexpected error.
Please contact the website administrator.


The following information is meant for the website developer for debugging purposes.
Error Occurred While Processing Request

Error Executing Database Query.

[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the varchar value ' 0.00' to data type int.
 
The error occurred in C:/websites/xplates/public/session_control.cfm: line 14
Called from C:/websites/abbott/shop/application.cfc: line 16
Called from C:/websites/xplates/public/session_control.cfm: line 14
Called from C:/websites/abbott/shop/application.cfc: line 16
12 : 	            select top 1 sessionID as SID
13 : 	            from sessions
14 : 	            where visitorNum = #cookie.vn#
15 : 	            and sessionID > (SELECT MAX(sessionID) - 50 FROM sessions)
16 : 	            order by sessionID desc

SQLSTATE   22018
DATASOURCE   abbott
VENDORERRORCODE   245
SQL    select top 1 sessionID as SID from sessions where visitorNum = 132031 and sessionID > (SELECT MAX(sessionID) - 50 FROM sessions) order by sessionID desc
Resources:

Browser   CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address   54.242.115.55
Referrer  
Date/Time   26-Mar-19 02:17 PM
Stack Trace
at cfsession_control2ecfm1164262541.runPage(C:/websites/xplates/public/session_control.cfm:14) at cfapplication2ecfc1668784698$funcONREQUESTSTART.runFunction(C:/websites/abbott/shop/application.cfc:16) at cfsession_control2ecfm1164262541.runPage(C:/websites/xplates/public/session_control.cfm:14) at cfapplication2ecfc1668784698$funcONREQUESTSTART.runFunction(C:/websites/abbott/shop/application.cfc:16)

java.sql.SQLDataException: [Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the varchar value '      0.00' to data type int.
	at macromedia.jdbc.sqlserverbase.ddca.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddca.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.b(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddb9.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.v(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.tds.ddr.a(Unknown Source)
	at macromedia.jdbc.sqlserver.ddj.m(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.e(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.a(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.v(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.r(Unknown Source)
	at macromedia.jdbc.sqlserverbase.ddel.execute(Unknown Source)
	at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1442)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1201)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1131)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:406)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1059)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:688)
	at cfsession_control2ecfm1164262541.runPage(C:\websites\xplates\public\session_control.cfm:14)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:244)
	at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:444)
	at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:2799)
	at cfapplication2ecfc1668784698$funcONREQUESTSTART.runFunction(C:\websites\abbott\shop\application.cfc:16)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:472)
	at coldfusion.filter.SilentFilter.invoke(SilentFilter.java:47)
	at coldfusion.runtime.UDFMethod$ArgumentCollectionFilter.invoke(UDFMethod.java:368)
	at coldfusion.filter.FunctionAccessFilter.invoke(FunctionAccessFilter.java:55)
	at coldfusion.runtime.UDFMethod.runFilterChain(UDFMethod.java:321)
	at coldfusion.runtime.UDFMethod.invoke(UDFMethod.java:220)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:655)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:444)
	at coldfusion.runtime.TemplateProxy.invoke(TemplateProxy.java:414)
	at coldfusion.runtime.AppEventInvoker.invoke(AppEventInvoker.java:108)
	at coldfusion.runtime.AppEventInvoker.onRequestStart(AppEventInvoker.java:278)
	at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:417)
	at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:48)
	at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
	at coldfusion.filter.PathFilter.invoke(PathFilter.java:112)
	at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:94)
	at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:79)
	at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
	at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
	at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:58)
	at coldfusion.filter.GlobalsFilter.invoke(GlobalsFilter.java:38)
	at coldfusion.filter.DatasourceFilter.invoke(DatasourceFilter.java:22)
	at coldfusion.filter.CachingFilter.invoke(CachingFilter.java:62)
	at coldfusion.CfmServlet.service(CfmServlet.java:219)
	at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:89)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:42)
	at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:46)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
	at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:928)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:414)
	at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:204)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:539)
	at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:298)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)