[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

Gerelateerde posts	Antwoorden	Weergaven
"The character encoding of the HTML document was not declared" when connecting to odoo11 server error odoo11	0 nov. 21	4237
How to solved this SQL error ?? Opgelost query sql	1 sep. 21	4283
Error: The field `effective_date` does not exist - odoo 11 error odoo11	1 nov. 19	6041
Odoo Server Error "unable to create thread pipe" error reporting odoo11	0 jan. 22	5124
How to print tree_view from sql query in odoo 11 query sql tree_view	0 okt. 21	1691

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!