Odoo Help


OpenERP/Odoo - Quote inside a string is not working - cr.execute(SQL)

on 8/2/16, 3:58 AM 833 views

Hi all,

In OpenERP 7 , I am using a cr.execute to execute a SQL Request

cr.execute('select distinct(value) from ir_translation where name = \'product.bat3,name\' and src = \''+ str(res_bat[j][0].encode('utf-8'))+'\' and res_id = '+ str(res_bat[j][1])+' and lang = \''+ str(line2.partner_id.lang)+'\'')

However, my string res_bat[j][0] is a string with a quote. The string is: test's Thus I have the error bellow:

ProgrammingError: syntax error at or near "s"
LINE 1: ... where name = 'product.bat3,name' and src = 'test's' and res...

How can I modify my SQL request to correct this error?

Many thanks,


--Qutechs, Ahmed M.Elmubarak--

Qutechs, Ahmed M.Elmubarak
On 8/2/16, 5:48 AM


as a quick workaround you can use:

res_bat[j][0].replace("'", "''")

So with this double single quotes the postgres can skip the single quote ...

Hope this could helps ...

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 8/2/16, 3:58 AM
Seen: 833 times
Last updated: 8/2/16, 5:48 AM