sql - openerp:在where子句中使用变量的值

abe= []
abibiti=1
self.cr.execute("SELECT name FROM account_analytic_account where parent_id=abibiti")
for t in self.cr.fetchall():
for item in t:
    abe.append(item)

我想用变量“abibiti”的值签入where子句，有人能帮我吗

最佳答案

您在cr.execute中编写查询的方式有一些问题。请改为：

abe= []
abibiti=1
cr.execute("SELECT name FROM account_analytic_account where parent_id=%s"%(abibiti))
for t in cr.fetchall():
    for item in t:
        abe.append(item)