topic Re: Query tool�?�: query failed to execute. Unable to complete operation, in ArcGIS Viewer for Silverlight Questions

Query tool???: query failed to execute. Unable to complete operation,

JamalNUMAN — Fri, 31 May 2013 19:32:32 GMT

Query tool???: query failed to execute. Unable to complete operation,

I tried to use the ???Query tool??? recently available to search values based on multiple fields/operations. Unfortunately, I got the message below (despite the fact that the value I???m searching is there!):

[ATTACH=CONFIG]24874[/ATTACH], [ATTACH=CONFIG]24875[/ATTACH]

What might be the issue here?

Sample data is attached

Thank you

Best

Jamal

Re: Query tool�?�: query failed to execute. Unable to complete operation,

BrianLeroux — Tue, 04 Jun 2013 18:28:07 GMT

The single quote in your selected value looks supsect to me. I would imagine that the query string looks something like Where CommunityNameForParcel_English = ''Atria'. That would cause and error because the first 2 quotes closed eachother out and the rest of the line is invalid. Id would be very easy to use Fiddler to check the query being sent to see if this is the case.

Re: Query tool�?�: query failed to execute. Unable to complete operation,

Anonymous User — Thu, 06 Jun 2013 17:14:19 GMT

Original User: Jamal432@gmail.com

The single quote in your selected value looks supsect to me. I would imagine that the query string looks something like Where CommunityNameForParcel_English = ''Atria'. That would cause and error because the first 2 quotes closed eachother out and the rest of the line is invalid. Id would be very easy to use Fiddler to check the query being sent to see if this is the case.

Thank you Brian for the answer.

Perfect. I tried to choose other values which don�??t contain quote and it works fine.

[ATTACH=CONFIG]25081[/ATTACH]

By the way, in the ADF, it works despite having quotes within the values

Best

Jamal