[11.0] SQL query problem

Question

I'm currently developing a function that can delete an order line with a click on a button and a SQL query.
My query has a syntax error but I'm inspiring myself with odoo's addons.

The error is this:
psycopg2.ProgrammingError: syntax error at or near "%"
LINE 2:            WHERE (product_id = %(product_id)s)AN... And my query is this:
DELETE FROM sale_order_line WHERE (product_id = %(product_id)s)AND (order_id = %(order_id)s)

Mitul Shingala · Accepted Answer

Hello
try will below code:
self._cr.execute("DELETE FROM  sale_order_line  WHERE  product_id =%s AND  order_id=%s ", (*product_id*,  *order_id* ))
in above query you have pass the interger value of variable product_id and order_id

相关帖文	回复	查看
"The character encoding of the HTML document was not declared" when connecting to odoo11 server error odoo11	0 11月 21	3239
How to solved this SQL error ?? 已解决 query sql	1 9月 21	2960
Error: The field `effective_date` does not exist - odoo 11 error odoo11	1 11月 19	4935
Odoo Server Error "unable to create thread pipe" error reporting odoo11	0 1月 22	3992
How to print tree_view from sql query in odoo 11 query sql tree_view	0 10月 21	1691

此问题已终结

喜欢讨论吗？不要只阅读，加入进来！