AutoComplete Box with Apostrophes

Permanently deleted user

13. Juli 2015 21:33

Hello All

I have a address search completed through an AutoComplete Box.

A couple streets have a Apostrophe's in the names which causes the Search to Crash. ie. O'Brien Court

The AutoComplete works just fine, I can get the address to populate, however when I search i Get an 'One or more Errors occured' error.

 

Any Thoughts?

Chris

 

 

0

• 

  Nico Burgerhart

  13. Juli 2015 21:57

  You get an error on a query task, the SQL Where clause is not valid.

  You should add a replace action to your workflow to double the single quotes.

  E.g. O'Brien Court > O''Brien Court

  0
• 

  Permanently deleted user

  13. Juli 2015 22:03

  here's the way we replace the single quote:

  Assign Activity:

  To - street

  Value - street.ToString().Replace("'","''")

  0
• 

  Permanently deleted user

  13. Juli 2015 22:28

  Thanks for the replies

  The Assign Task worked perfectly

  Thanks!

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.