create query string apostrophe
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
-
The easiest way to escape a single quote in a string to double up the quote, e.g. with a replace. 0 -
Thanks Nico. 0
Du måste logga in om du vill lämna en kommentar.
Kommentarer
2 kommentarer