Single Quote in Query Task - Failure

[LakshmananVenkatesan]

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

[DominiqueBroux]

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?

[LakshmananVenkatesan]

It is failing still : Sample

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

[LakshmananVenkatesan · Accepted solution]

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

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

[YousefQuran]

Thank you, it works fine!