Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




[WebService]SQLs with encoding error?

web-app

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
ffxf
Replies (2)
helpful
0
not helpful

Set the resources property to the user id not name.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

thank a lot!

it works! yeah~~


ffxf
· 1
ffxf