Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Incorrect syntax near ')'.
|
|
The error occurred in E:/inetpub/wwwroot/best-selling-guns-2014.cfm: line 177
Called from |SQLServer|6.0.0.1282|: line 1103
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
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 1103
Called from |SQLServer|6.0.0.1282|: line 980
Called from |SQLServer|6.0.0.1282|: line 1124
Called from |SQLServer|6.0.0.1282|: line 193
Called from |SQLServer|6.0.0.1282|: line 1153
Called from |SQLServer|6.0.0.1282|: line 4126
Called from |SQLServer|6.0.0.1282|: line 4275
Called from |SQLServer|6.0.0.1282|: line 2035
Called from |SQLServer|6.0.0.1282|: line 632
Called from |SQLServer|6.0.0.1282|: line 2699
Called from |SQLServer|6.0.0.1282|: line 2508
Called from |SQLServer|6.0.0.1282|: line 1358
Called from |SQLServer|6.0.0.1282|: line 4478
Called from E:/inetpub/wwwroot/best-selling-guns-2014.cfm: line 177
|
175 : INNER JOIN dbo.tb_skus b WITH (NOLOCK)
176 : ON (a.sku_id = b.sku_id)
177 : WHERE date_disp>'2014-01-01 00:00:00' and date_disp< '2015-01-01 00:00:00' and b.style_id in (#top_sale#)
178 : group by style order by count desc
179 : </CFQUERY>
|
|
SQLSTATE |
HY000 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
celerantsql |
VENDORERRORCODE |
102 |
SQL |
select distinct a.style, COUNT(a.style) AS count, max(b.sku_id) as sku_id, max(b.style_id) as style_id, max(a.brand) as brand, max(a.description) as description, max(a.of1) as of1, max(a.of2) as of2, max(a.of3) as of3, max(a.of4) as of4, max(a.of5) as of5, max(a.of6) as of6, max(a.of19) as of19, max(a.of20) as of20
FROM tb_firearm_acq_disp a
INNER JOIN dbo.tb_skus b WITH (NOLOCK)
ON (a.sku_id = b.sku_id)
WHERE date_disp>'2014-01-01 00:00:00' and date_disp< '2015-01-01 00:00:00' and b.style_id in ()
group by style order by count desc |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
10.200.2.4 |
Referrer |
http://sportsmansoutdoorsuperstore.com/best-selling-guns-2014.cfm/top_selling_handguns_with_laser |
Date/Time |
04-Dec-24 10:42 AM |
|