Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
|
| |
The error occurred in C:/home/basicswork.tools/wwwroot/vendproduct.cfm: line 1200
Called from C:/home/basicswork.tools/wwwroot/vendproduct.cfm: line 1190
Called from C:/home/basicswork.tools/wwwroot/router.cfm: line 24
Called from C:/home/basicswork.tools/wwwroot/vendproduct.cfm: line 1200
Called from C:/home/basicswork.tools/wwwroot/vendproduct.cfm: line 1190
Called from C:/home/basicswork.tools/wwwroot/router.cfm: line 24
|
1198 : left join tb_sku_buckets b with(nolock) on b.sku_id = sk.sku_id and b.STORE_ID = 1
1199 : left join tb_sku_buckets b90 with(nolock) on b90.sku_id = sk.sku_id and b90.STORE_ID = 90
1200 : where s.web_product='Y' and s.style_id in(#product.STYLE_ID#)
1201 : and (b90.QOH > 0 OR b.QOH > 0)
1202 : group by s.style_id
|
|
| SQLSTATE |
HY000 |
| DATASOURCE |
basicsworkicumulus |
| 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:
|
| Browser |
CCBot/2.0 (https://commoncrawl.org/faq/) |
| Remote Address |
18.97.9.171 |
| Referrer |
|
| Date/Time |
05-Dec-24 10:51 AM |
|
