[WebService]SQLs with encoding error?
the filter send to service like this:
IssuesFilterEN filter = new IssuesFilterEN();
filter.ProjectID = "1|2";
filter.ExcludeClosed = true;
filter.Components = "0";
filter.Versions = "-1";
filter.IssueID = "";
filter.IssueTypes = "0";
filter.IssuePriorities = "0";
filter.IssueStatus = "0";
filter.IssueResolutions = "0";
filter.RiskLevels = "0";
filter.Resources = Utility.CurrentUser.UserName;
filter.ReportedByUserName = string.Empty;
filter.SearchKeywords = string.Empty;
filter.CreatedAfter = string.Empty;
filter.CreatedBefore = string.Empty;
filter.RevisedAfter = string.Empty;
filter.RevisedBefore = string.Empty;
but i got the error info from Test Unit:
[SQL: SELECT this.issueid as issueid144, .... WHERE this.projid in (?, ?) and not this.issstatus = ? and resources3.userid in (?) ORDER BY this_.revised desc] ---> Failed to convert parameter value from a String to a Int32. ---> Input string was not in a correct format.
i thought that is encoding errors.but the error code is ONLY NUMERIC. i feel puzzled.
|
ffxf
· 1 |
|
| Tuesday, December 11, 2007, 2:35:12 PM | |




