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.
I am working with odoo9 and trying sql query.
Here is what i have tried:
sql = self.env.cr.execute("SELECT name,model_id, res_id, user_id, method, field_id, old_value, new_value, old_value_text, new_value_text FROM auditlog_log_line LEFT JOIN auditlog_log ON auditlog_log_line.id = auditlog_log.id;")
self.deadline = self.env.cr.fetchone()
result = self.deadline
self.env.cr.execute("INSERT INTO seetek_request (name) VALUES ("+result+")")
And here is what i have got as error:
2015-12-15 09:11:47,277 6560 INFO seetek openerp.sql_db: Programming error: syntax error at or near "Langlais"
LIGNE 1 : INSERT INTO seetek_request (name) VALUES (Antoine Langlais)
, in query INSERT INTO seetek_request (name) VALUES (Antoine Langlais)
2015-12-15 09:11:47,277 6560 ERROR seetek openerp.http: Exception during JSON request handling.
Can anyone help please.
Thanks a lot in advance.
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: 12/15/15, 4:16 AM|
|Seen: 1486 times|
|Last updated: 1/18/16, 3:23 PM|