[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

Relaterade inlägg	Svar	Vyer
"The character encoding of the HTML document was not declared" when connecting to odoo11 server error odoo11	0 nov. 21	4294
How to solved this SQL error ?? Löst query sql	1 sep. 21	4441
Error: The field `effective_date` does not exist - odoo 11 error odoo11	1 nov. 19	6112
Odoo Server Error "unable to create thread pipe" error reporting odoo11	0 jan. 22	5203
How to print tree_view from sql query in odoo 11 query sql tree_view	0 okt. 21	1691

Denna fråga har flaggats

Njuter du av diskussionen? Läs inte bara, delta också!