samedi 26 mars 2016

python sqlite3 line not evaluating correctly

I must have a mistake in here somewhere but I cannot find it, not terribly experienced with writing SQL...

>>> db.c.execute('INSERT INTO {tn} ({c1n}, {c2n}) VALUES ({wn}, {f})'.\
...    format(tn=db.table1, c1n=db.column1, c2n=db.column2, wn='someword', f=1))

it is giving me this traceback...

Traceback (most recent call last):
    File "<stdin>", line 2, in <module>
    sqlite3.OperationalError: no such column: someword

'someword' should be the value it is inserting, not the column it is looking for, right?

Aucun commentaire:

Enregistrer un commentaire