Error Executing Database Query.
|
|
[Macromedia][SQLServer JDBC Driver][SQLServer]Conversion failed when converting the nvarchar value '8283"' to data type int.
|
| |
The error occurred in D:/Websites/newcriterion.ecomsolutions.net/cfc/model/readcontent.cfc: line 105
Called from D:/Websites/newcriterion.ecomsolutions.net/articles.cfm: line 15
Called from D:/Websites/newcriterion.ecomsolutions.net/cfc/model/readcontent.cfc: line 105
Called from D:/Websites/newcriterion.ecomsolutions.net/articles.cfm: line 15
|
103 : left join issues i on i.IssueId = a.IssueId
104 : WHERE ArticleID = <cfif thurl eq 'Kramer'> 7345 <cfelse> <cfqueryparam cfsqltype="cf_sql_varchar" value="#thurl#"> </cfif>
105 : #sStatusClause#
106 : </cfquery>
107 :
|
|
| VENDORERRORCODE |
245 |
| SQLSTATE |
22018 |
| SQL |
SELECT A.*,
d.Name, i.month, i.year, i.volume, i.number,
dbo.GetAuthors(A.ArticleID) AS Authors
FROM Articles A
left join departments d on a.DepartmentID = d.DepartmentID
left join issues i on i.IssueId = a.IssueId
WHERE ArticleID = (param 1) AND A.status = 1 |
| DATASOURCE |
newcriterion_work |
|
|
Resources:
|
| Browser |
Mozilla/5.0 (Windows NT 6.3; WOW64; rv:47.0) Gecko/20100101 Firefox/47.0 |
| Remote Address |
62.210.77.51 |
| Referrer |
|
| Date/Time |
14-Aug-16 08:20 PM |
|