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

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

mzorbis

Guest
Hi Anvi, At the moment I've got the webapi.log only (replaced actual IP address with 0.0.0.0 intentionally): [2018-03-23 08:30:53,666] [RID=01edb035-00f8-44de-8140-0017cd16e3ba] [Comp=webapi] [CustId=630468] [IP=0.0.0.0] selectQuery query=SELECT id FROM locationAddress WHERE externalReference1 = 'BB''S BABY DONUTS' AND addressAccount = '949184' [2018-03-23 08:30:53,670] [RID=01edb035-00f8-44de-8140-0017cd16e3ba] [Comp=webapi] [CustId=630468] [IP=0.0.0.0] ===> Error in thread http-apr-8080-exec-9 at 03/23/2018 08:30 AM: selectQuery error: SELECT A.OBJ_ID FROM RB_OBJ_DATA A WHERE A.OBJ_DEF_ID=640129 AND (A.STR5 = 630488'S BABY DONUTS' AND A.INTG3 = '949184') com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: 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 ''S BABY DONUTS' AND A.INTG3 = '949184')' at line 1 Cheers, Marcin.

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