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 ')'.
The error occurred in C:/home/cgsportinggoods.com/wwwroot/vendproduct.cfm: line 943 Called from C:/home/cgsportinggoods.com/wwwroot/vendproduct.cfm: line 933 Called from C:/home/cgsportinggoods.com/wwwroot/router.cfm: line 21 Called from C:/home/cgsportinggoods.com/wwwroot/vendproduct.cfm: line 943 Called from C:/home/cgsportinggoods.com/wwwroot/vendproduct.cfm: line 933 Called from C:/home/cgsportinggoods.com/wwwroot/router.cfm: line 21
941 : left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1
942 : left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90
943 : where s.web_product='Y' and s.style_id in(#product.STYLE_ID#)
944 : and (b90.QOH > 0 OR b.QOH > 0)
945 : group by s.style_id
SQLSTATE
HY000
DATASOURCE
candgsportinggoodsicumulus
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
Search the Knowledge Base to find a solution to your problem.
Browser
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote Address
18.220.190.128
Referrer
Date/Time
19-May-24 10:39 AM
Stack Trace
at cfvendproduct2ecfm1306968151._factor44(C:/home/cgsportinggoods.com/wwwroot/vendproduct.cfm:943) at cfvendproduct2ecfm1306968151.runPage(C:/home/cgsportinggoods.com/wwwroot/vendproduct.cfm:933) at cfrouter2ecfm738401844.runPage(C:/home/cgsportinggoods.com/wwwroot/router.cfm:21)
at cfvendproduct2ecfm1306968151._factor44(C:/home/cgsportinggoods.com/wwwroot/vendproduct.cfm:943) at cfvendproduct2ecfm1306968151.runPage(C:/home/cgsportinggoods.com/wwwroot/vendproduct.cfm:933) at cfrouter2ecfm738401844.runPage(C:/home/cgsportinggoods.com/wwwroot/router.cfm:21)
java.sql.SQLException: [Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
at macromedia.jdbc.sqlserverbase.ddcw.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcw.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.b(Unknown Source)
at macromedia.jdbc.sqlserverbase.ddcv.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.c(Unknown Source)
at macromedia.jdbc.sqlserver.dda4.m(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.e(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.a(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.x(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.t(Unknown Source)
at macromedia.jdbc.sqlserverbase.dde7.execute(Unknown Source)
at coldfusion.server.j2ee.sql.JRunStatement.execute(JRunStatement.java:359)
at coldfusion.sql.Executive.executeQuery(Executive.java:1567)
at coldfusion.sql.Executive.executeQuery(Executive.java:1317)
at coldfusion.sql.Executive.executeQuery(Executive.java:1247)
at coldfusion.sql.SqlImpl.execute(SqlImpl.java:427)
at coldfusion.tagext.sql.QueryTag.executeQuery(QueryTag.java:1211)
at coldfusion.tagext.sql.QueryTag.startQueryExecution(QueryTag.java:841)
at coldfusion.tagext.sql.QueryTag.doEndTag(QueryTag.java:794)
at cfvendproduct2ecfm1306968151._factor44(C:\home\cgsportinggoods.com\wwwroot\vendproduct.cfm:943)
at cfvendproduct2ecfm1306968151.runPage(C:\home\cgsportinggoods.com\wwwroot\vendproduct.cfm:933)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
at coldfusion.runtime.CfJspPage._emptyTcfTag(CfJspPage.java:4329)
at cfrouter2ecfm738401844.runPage(C:\home\cgsportinggoods.com\wwwroot\router.cfm:21)
at coldfusion.runtime.CfJspPage.invoke(CfJspPage.java:262)
at coldfusion.tagext.lang.IncludeTag.handlePageInvoke(IncludeTag.java:735)
at coldfusion.tagext.lang.IncludeTag.doStartTag(IncludeTag.java:565)
at coldfusion.filter.CfincludeFilter.invoke(CfincludeFilter.java:65)
at coldfusion.filter.ApplicationFilter.invoke(ApplicationFilter.java:595)
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:96)
at coldfusion.filter.BrowserDebugFilter.invoke(BrowserDebugFilter.java:78)
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:226)
at coldfusion.bootstrap.BootstrapServlet.service(BootstrapServlet.java:311)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
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:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:377)
at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:463)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:889)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1743)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191)
at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.base/java.lang.Thread.run(Thread.java:834)