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]No more data available to read.
The error occurred in C:/websites/Skicountry/includes/sidenav.cfm: line 385 Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1 Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1 Called from C:/websites/Skicountry/category.cfm: line 139 Called from |SQLServer|6.0.0.1282|: line 1048 Called from |SQLServer|6.0.0.1282|: line 980 Called from |SQLServer|6.0.0.1282|: line 1132 Called from |SQLServer|6.0.0.1282|: line 840 Called from |SQLServer|6.0.0.1282|: line 719 Called from |SQLServer|6.0.0.1282|: line 1772 Called from |SQLServer|6.0.0.1282|: line 155 Called from |SQLServer|6.0.0.1282|: line 4600 Called from |SQLServer|6.0.0.1282|: line 1376 Called from |SQLServer|6.0.0.1282|: line 2505 Called from |SQLServer|6.0.0.1282|: line 1358 Called from |SQLServer|6.0.0.1282|: line 4478 Called from |SQLServer|6.0.0.1282|: line 1048 Called from |SQLServer|6.0.0.1282|: line 980 Called from |SQLServer|6.0.0.1282|: line 1132 Called from |SQLServer|6.0.0.1282|: line 840 Called from |SQLServer|6.0.0.1282|: line 719 Called from |SQLServer|6.0.0.1282|: line 1772 Called from |SQLServer|6.0.0.1282|: line 155 Called from |SQLServer|6.0.0.1282|: line 4600 Called from |SQLServer|6.0.0.1282|: line 1376 Called from |SQLServer|6.0.0.1282|: line 2505 Called from |SQLServer|6.0.0.1282|: line 1358 Called from |SQLServer|6.0.0.1282|: line 4478 Called from C:/websites/Skicountry/includes/sidenav.cfm: line 385 Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1 Called from C:/websites/Skicountry/includes/sidenav.cfm: line 1 Called from C:/websites/Skicountry/category.cfm: line 139
383 : SELECT DISTINCT siz, max(size_order) as size_order
384 : FROM tb_size_entries
385 : WHERE upper(siz) IN ('#replace(this.overallSizeList,",","','","all")#') and upper(siz) <> 'NS' and upper(siz) <> 'N/S'
386 : GROUP BY siz
387 : ORDER BY max(size_order), siz
SQLSTATE
08S01
EXCEPTIONS
<small><i>not set</i></small>
DATASOURCE
celerantSQL
SQL
SELECT DISTINCT siz, max(size_order) as size_order
FROM tb_size_entries
WHERE upper(siz) IN ('10','11','12','13','9.5','11.5') and upper(siz) <> 'NS' and upper(siz) <> 'N/S'
GROUP BY siz
ORDER BY max(size_order), siz
at cfsidenav2ecfm995677278._factor13(C:/websites/Skicountry/includes/sidenav.cfm:385) at cfsidenav2ecfm995677278._factor15(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfsidenav2ecfm995677278.runPage(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfcategory2ecfm1749867363.runPage(C:/websites/Skicountry/category.cfm:139) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1048) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1132) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:840) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:719) at macromedia.jdbc.sqlserver.base.BaseConnection.a(|SQLServer|6.0.0.1282|:1772) at macromedia.jdbc.sqlserver.tds.g.b(|SQLServer|6.0.0.1282|:155) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4600) at macromedia.jdbc.sqlserver.SQLServerImplStatement.cb(|SQLServer|6.0.0.1282|:1376) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2505) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1048) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1132) at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:840) at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:719) at macromedia.jdbc.sqlserver.base.BaseConnection.a(|SQLServer|6.0.0.1282|:1772) at macromedia.jdbc.sqlserver.tds.g.b(|SQLServer|6.0.0.1282|:155) at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4600) at macromedia.jdbc.sqlserver.SQLServerImplStatement.cb(|SQLServer|6.0.0.1282|:1376) at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2505) at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358) at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478) at cfsidenav2ecfm995677278._factor13(C:/websites/Skicountry/includes/sidenav.cfm:385) at cfsidenav2ecfm995677278._factor15(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfsidenav2ecfm995677278.runPage(C:/websites/Skicountry/includes/sidenav.cfm:1) at cfcategory2ecfm1749867363.runPage(C:/websites/Skicountry/category.cfm:139)
java.sql.SQLNonTransientConnectionException: [Macromedia][SQLServer JDBC Driver]No more data available to read.
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1048)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1132)
at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:840)
at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:719)
at macromedia.jdbc.sqlserver.base.BaseConnection.a(|SQLServer|6.0.0.1282|:1772)
at macromedia.jdbc.sqlserver.tds.g.b(|SQLServer|6.0.0.1282|:155)
at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4600)
at macromedia.jdbc.sqlserver.SQLServerImplStatement.cb(|SQLServer|6.0.0.1282|:1376)
at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2505)
at macromedia.jdbc.sqlserver.base.gr.nM(|SQLServer|6.0.0.1282|:1358)
at macromedia.jdbc.sqlserver.base.gr.execute(|SQLServer|6.0.0.1282|:4478)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1613)
at coldfusion.sql.Executive.executeQuery(Executive.java:1355)
at coldfusion.sql.Executive.executeQuery(Executive.java:1285)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1247)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:876)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:821)
at cfsidenav2ecfm995677278._factor13(C:\websites\Skicountry\includes\sidenav.cfm:385)
at cfsidenav2ecfm995677278._factor15(C:\websites\Skicountry\includes\sidenav.cfm:1)
at cfsidenav2ecfm995677278.runPage(C:\websites\Skicountry\includes\sidenav.cfm:1)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:5274)
at cfcategory2ecfm1749867363.runPage(C:\websites\Skicountry\category.cfm:139)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:257)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:749)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:578)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:613)
at coldfusion.filter.RequestMonitorFilter.invoke(RequestMonitorFilter.java:43)
at coldfusion.filter.MonitoringFilter.invoke(MonitoringFilter.java:40)
at coldfusion.filter.PathFilter.invoke(PathFilter.java:162)
at coldfusion.filter.IpFilter.invoke(IpFilter.java:45)
at coldfusion.filter.ExceptionFilter.invoke(ExceptionFilter.java:97)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:81)
at coldfusion.filter.ClientScopePersistenceFilter.invoke(ClientScopePersistenceFilter.java:28)
at coldfusion.filter.BrowserFilter.invoke(BrowserFilter.java:38)
at coldfusion.filter.NoCacheFilter.invoke(NoCacheFilter.java:60)
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:231)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:199)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at coldfusion.monitor.event.MonitoringServletFilter.doFilter(MonitoringServletFilter.java:46)
at coldfusion.bootstrap.BootstrapFilter.doFilter(BootstrapFilter.java:47)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:168)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:168)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
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:357)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:448)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:936)
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:1190)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
at java.base/java.lang.Thread.run(Thread.java:834)
