[Progress Communities] [Progress OpenEdge ABL] Forum Post: What's the correct way to escape single quote character (') in a string literal for selectQ

  • Thread starter Thread starter mzorbis
  • Start date Start date
Status
Not open for further replies.
M

mzorbis

Guest
Hi, I seem to have a problem with using two single quote characters ('') to escape a single quote character (') in a string literal when calling selectQuery SOAP API function. The escaped string used for query argument of selectQuery call is: SELECT id FROM test1 WHERE externalReference1 = 'TEST''DATA' This produces a MySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''DATA)' at line 1 Can you help, please? Thanks.

Continue reading...
 
Status
Not open for further replies.
Back
Top