Insert single quotes into SQL Query

1
Hi People, How can I transform the Mendix sql Query: 'Select attr1,attr2,attr3,attr4 from TABLEAU where attr1 = “'+$Search/PID+'”;'   to a valid oracle sql Query: Select attr1,attr2,attr3,attr4 from TABLEAU where attr1  = '206298'; Specialy, how can I insert quotes like ‘$Search/PID’ I Got an error: com.mendix.modules.microflowengine.MicroflowException: com.mendix.systemwideinterfaces.MendixRuntimeException: java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended Many ​t​​​​hanks
asked
1 answers
2

Oracle wants single quotes in the WHERE attr1 = '1234'. So try this:

'Select attr1,attr2,attr3,attr4 from TABLEAU where attr1 = '''+$Search/PID+''';'

Mind the triple single quote.

answered