search

CUAHSI / HydroServer

BSD 3-Clause "New" or "Revised" License
8 stars 4 forks source link

HydroServer Interactive - Typing an Apostrophe Error #126

Open xhqiao89 opened 7 years ago

xhqiao89 commented 7 years ago

danames[CodePlex]
Comment from a user: Whenever I type in the text boxes and put an apostrophe (for example Coeur d’Alene) it gives an error message. This occured on the bio assessment form when typing in the quotOther Assessment Observations and Notesquot box.

xhqiao89 commented 7 years ago

RussNelson[CodePlex]
Very likely due to insufficient quoting of entered strings. SQL uses the single quote as a string delimiter, so if you (that is to say, the software that takes your input and turns it into SQL) don't put backslashes in front of them, they confuse the SQL parser. Try writing Coeur d\'Alene. I'll bet you a doughnut it works.