$0.00

product code:

UPC:

Brand:

availability:Currently out of Stock

Leave a Review!

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]Incorrect syntax near ')'.

1545 : 		left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1
1546 : 		left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90
1547 : 		where s.web_product='Y' and s.style_id in(#product.STYLE_ID#)
1548 : 		and (b90.QOH > 0 OR b.QOH > 0)
1549 : 		group by s.style_id

SQLSTATE	HY000
EXCEPTIONS	<small><i>not set</i></small>
DATASOURCE	bergsouticumulus
VENDORERRORCODE	102
SQL	Select CASE when MIN(b90.PRICE) > 0 then MIN(b90.PRICE) else MIN(b.PRICE) END AS MIN_PRICE, CASE when MAX(b90.PRICE) > 0 then MAX(b90.PRICE) else MAX(b.PRICE) END AS MAX_PRICE, CASE when MAX(b90.PRICE) > 0 then MAX(b90.PRICE) else MAX(b.PRICE) END AS PRICE from tb_styles s with(nolock) left join tb_skus sk with(nolock) on sk.style_id = s.style_id left join tb_sku_lookups sl with (nolock) on (sl.sku_id=sk.SKU_ID and len(sl.lookup) > 10) left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1 left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90 where s.web_product='Y' and s.style_id in() and (b90.QOH > 0 OR b.QOH > 0) group by s.style_id

Resources:

Check the ColdFusion documentation to verify that you are using the correct syntax.
Search the Knowledge Base to find a solution to your problem.

Browser	CCBot/2.0 (https://commoncrawl.org/faq/)
Remote Address	18.97.14.87
Referrer
Date/Time	16-Jun-25 10:08 PM

Stack Trace

java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
	at macromedia.jdbc.sqlserver.base.BaseExceptions.b(|SQLServer|6.0.0.1282|:1103)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:980)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:1124)
	at macromedia.jdbc.sqlserver.base.BaseExceptions.a(|SQLServer|6.0.0.1282|:193)
	at macromedia.jdbc.sqlserver.tds.s.rZ(|SQLServer|6.0.0.1282|:1153)
	at macromedia.jdbc.sqlserver.tds.s.a(|SQLServer|6.0.0.1282|:4126)
	at macromedia.jdbc.sqlserver.tds.s.c(|SQLServer|6.0.0.1282|:4275)
	at macromedia.jdbc.sqlserver.SQLServerImplStatement.ch(|SQLServer|6.0.0.1282|:2035)
	at macromedia.jdbc.sqlserver.base.gr.cK(|SQLServer|6.0.0.1282|:632)
	at macromedia.jdbc.sqlserver.base.gr.G(|SQLServer|6.0.0.1282|:2699)
	at macromedia.jdbc.sqlserver.base.gr.nT(|SQLServer|6.0.0.1282|:2508)
	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:1649)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1391)
	at coldfusion.sql.Executive.executeQuery(Executive.java:1321)
	at coldfusion.sql.SqlImpl.execute(SqlImpl.java:425)
	at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1250)
	at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:877)
	at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:822)
	at cfvendproduct2ecfm1588833957._factor57(C:\home\bergsoutdoors.com\wwwroot\vendproduct.cfm:1547)
	at cfvendproduct2ecfm1588833957._factor59(C:\home\bergsoutdoors.com\wwwroot\vendproduct.cfm:1537)
	at cfvendproduct2ecfm1588833957.runPage(C:\home\bergsoutdoors.com\wwwroot\vendproduct.cfm:1)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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:5083)
	at cfrouter2ecfm1830228761.runPage(C:\home\bergsoutdoors.com\wwwroot\router.cfm:24)
	at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:251)
	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.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:842)

subscribe here for price alerts

Reviews