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