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.
Hi everyone : I have function :
def _getvalue_byIdquotations(self,req,dbname,Id_child): resgister=RegistryManager.get(dbname) sql= """ SELECT cvs_chil.codeproduct FROM cvs_quotations_cutproduct cvs_cut join cvs_quotations_product_child cvs_chil on cvs_cut.codeproduct_id=cvs_chil.codesystemdoor WHERE (cvs_cut.id_quotations = %d) """%(Id_child) with resgister.cursor() as cr: cr.execute(sql) restul=cr.fetchall() sql_exccute=''' SELECT cvs_cut.codeproduct_id FROM product_category cate where (cate.id in %s) '''%(restul) cr.execute(sql_exccute) restul_excute=cr.fetchall() return restul_excute
But when i excute ,it error "ProgrammingError: syntax error at or near "[""
can you help me ?
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 2/9/14, 10:43 PM|
|Seen: 1259 times|
|Last updated: 3/16/15, 8:10 AM|