text: Odoo Help
  Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
  CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
  ValueError: SQL query parameters should be a tuple, list or dict
  issues corrected
  def _random_letter(self, cr, uid, ids, name, args, context): num=[] for i in range(5): res = random.choice([1, 2, 3, 5, 9]) num.append(res) print (num) return num def _mytest_query(self, cr, uid, ids, name, args, context): cr.execute("""update checkroll_plucker set worker_name =concat('worker','%s') where id='1'""", self._random_letter(cr, uid, ids, name, args, context)) cr.commit()
  Error :
  File "/home/priyan/Software/openerp-7.0-20130309-002120/openerp/sql_db.py", line 219, in execute raise ValueError("SQL query parameters should be a tuple, list or dict; got %r" % (params,)) ValueError: SQL query parameters should be a tuple, list or dict; got 5
  also I'm still confusing in parameters which we pass in functions. i go through developer book also.but haven't got clear idea.i'll mention those below please correct me if they correct .!
  ex :
  self, cr, uid, ids, name, args, context self = call to current class of that method called cr = current row in the table uid = user id for check if he authorized or not for run this function name = column name we need to insert context = language/time details (but what is the use of it.more times it equals to
  hope now this will help you