Error Executing Database Query.
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the varchar value '20,20' to data type int.
|
|
The error occurred in E:/web_sites/Protocraft_67_CMG110/Show_Sub_Sub_Category.cfm: line 2
Called from E:/Web_Sites/Protocraft_67_CMG110/category.cfm: line 3
Called from |SQLServer|6.0.0.1282|: line 1055
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 1059
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 526
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 2703
Called from |SQLServer|6.0.0.1282|: line 525
Called from |SQLServer|6.0.0.1282|: line 1055
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 1059
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 526
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 2703
Called from |SQLServer|6.0.0.1282|: line 525
Called from E:/web_sites/Protocraft_67_CMG110/Show_Sub_Sub_Category.cfm: line 2
Called from E:/Web_Sites/Protocraft_67_CMG110/category.cfm: line 3
|
1 : <cfquery name="get_categories" datasource="Protocraft">
2 : select * from storeitems where CategoryID=<CFQUERYPARAM Value="#url.categoryid#"> and status = 'Active' and sub_sub_category=<CFQUERYPARAM Value="#url.sub_sub_category#"> order by sort_Order
3 : </cfquery>
4 :
|
|
SQLSTATE |
22018 |
EXCEPTIONS |
<small><i>not set</i></small> |
DATASOURCE |
Protocraft |
VENDORERRORCODE |
245 |
SQL |
select * from storeitems where CategoryID= (param 1) and status = 'Active' and sub_sub_category= (param 2) order by sort_Order |
|
Resources:
|
Browser |
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
Remote Address |
18.119.125.135 |
Referrer |
http://protocraft.com/category.cfm?Categoryid=20&Sub_Sub_Category=DL |
Date/Time |
19-Apr-24 11:13 PM |
|