how to create parameter in cr.execute in python for openerp

Question

i want to create 'select query' in cr.execte with string parameter and how to pass the parameter to return statement in python for openerp

Jagdish Panchal · Accepted Answer

Hi,,

cr.execute('select id from table_name where your_field=%s ', (patamerter1,))

Thanks

Fongoh Tayong · Answer

or in using self.env.cr.execute, you can do

self.env.cr.execute("DELETE from account_invoice_summary where invoice_id = %d" % (self.id))