Skip to Content
This question has been flagged
errorquerysqlsyntaxodoo11
1 Respondre
5777 Vistes
Avatar
Topieka

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)

 
Avatar
Descartar
Avatar
Mitul Shingala
Best 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

Avatar
Descartar
Topieka
Autor

Oh okay I see the mistake

Thanks for the help

Related Posts Respostes Vistes Activitat
"The character encoding of the HTML document was not declared" when connecting to odoo11 server
error odoo11
Avatar
0
de nov. 21
3237
How to solved this SQL error ?? Solved
query sql
Avatar
Avatar
1
de set. 21
2959
Error: The field `effective_date` does not exist - odoo 11
error odoo11
Avatar
Avatar
1
de nov. 19
4935
Odoo Server Error "unable to create thread pipe"
error reporting odoo11
Avatar
0
de gen. 22
3990
How to print tree_view from sql query in odoo 11
query sql tree_view
Avatar
0
d’oct. 21
1691