Overslaan naar inhoud
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Alle posts Personen Badges
Labels (Bekijk alle)
odoo accounting v14 pos v15
Over dit forum
Deze vraag is gerapporteerd
query
1 Beantwoorden
4955 Weergaven
Avatar
Usman Farzand

res = [(9999, 20109), (10000, 20110)]

self.env.cr.execute("""INSERT INTO magic_res_partner (magic_uniq_id, magic_customer_number) VALUES
%s """, tuple(res))



Error is %s
ERROR: not all arguments converted during string formatting


any solution
Avatar
Annuleer
Avatar
Prakash
Beste antwoord

Hello,

Inserting two values so two times use %s, %s  and res contains list of tuple so iterate in for loop and insert value one by one.

Example,

res = [(9999, 20109), (10000, 20110)]
for r in res:
    self.env.cr.execute("""INSERT INTO magic_res_partner (magic_uniq_id, magic_customer_number) VALUES (%s, %s) """,     tuple(r))
Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
How can I display data from database in form view
query
Avatar
0
sep. 23
6206
How can i write update query in a function? Opgelost
query
Avatar
Avatar
Avatar
Avatar
3
jan. 20
12654
ParseError: "duplicate key value violates unique constraint "res_groups_name_uniq"?
query
Avatar
0
dec. 23
8035
warehouse and location query
query
Avatar
0
mrt. 15
3219
How to create a method that will display values from database to a selection type field?
query
Avatar
0
mrt. 15
3432