create query string apostrophe

Justin Wolff

December 10, 2018 20:35

I have a workflow to select from a list of communities.  One community name includes an apostrophe (O'Neill) which cases an error, but otherwise things work fine.

 

This is what we have for Value for the System.Activities.Statements.Assign activity:

 

"Community = '"+comm.ToString() +"'" & " AND " & "Comm_Type <> 'Etj'"

 

The query returns only records where the community type ('Comm_Type') does not equal extra-territorial jurisdiction ('Etj').  O'Neill shows up in the dropdown list, but when selected returns an error - all other communities work fine.  We're pretty sure the apostrophe is causing problems, not sure how to work around this.  Thanks

0

• 

  Nico Burgerhart

  December 10, 2018 21:49

  The easiest way to escape a single quote in a string to double up the quote, e.g. with a replace.

  0
• 

  Justin Wolff

  December 20, 2018 14:12

  Thanks Nico.

  0

Please sign in to leave a comment.