topic Re: Single Quote in Query Task - Failure in ArcGIS API for Silverlight Questions

Single Quote in Query Task - Failure

LakshmananVenkatesan — Tue, 07 Jun 2011 12:48:15 GMT

All,

Whenever we do a query task with column value having a single quote ESRI query task fails. We are using 2.1 version. Please let us know if there is any solution for this.

Thanks
SR

Re: Single Quote in Query Task - Failure

DominiqueBroux — Tue, 07 Jun 2011 13:11:13 GMT

As the single quote is used as string delimiter, you have to escape it if you want it inside a string.

Something like:
query.Where = "City = 'Bois D\'Arcy' ";

Are you talking about this case or something else?

Re: Single Quote in Query Task - Failure

LakshmananVenkatesan — Tue, 07 Jun 2011 13:22:24 GMT

It is failing still : Sample

user = 'OU=BOIS D\'XYZ EXPLORATION ABC,DC=HIGH2010W,DC=COM'

Re: Single Quote in Query Task - Failure

LakshmananVenkatesan — Tue, 07 Jun 2011 13:33:18 GMT

Thanks. Solution Found, we need to add another single quote

user = 'OU=BOIS D''XYZ EXPLORATION ABC,DC=HIGH2010W,DC=COM'

Re: Single Quote in Query Task - Failure

YousefQuran — Tue, 26 Apr 2016 06:48:04 GMT

Thank you, it works fine!