Python sqlite3 Value Error

Question

I have been getting this error and have stuck a few hours trying to understand what I am doing wrong. I have use this template for successfully importing into sqlite3 many many times in the past.

def TestImport():
   con = sqlite3.connect("test.db")
   con.execute("CREATE TABLE IF NOT EXISTS TestTable(ColA,ColB)")
   data=[('x','y')]
   stmt = "INSERT INTO TestTable VALUES(?,?)"
   con.execute(data,stmt)
   con.commit()
   con.close()

However this time I am getting this error:

ValueError: operation parameter must be str or unicode

here

con.execute(data,stmt)

pp_ · Accepted Answer · 2016-02-28 20:27:08Z

1

It should be

con.execute(stmt, data[0])

answered Feb 28, 2016 at 20:27

pp_

3,5134 gold badges21 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Python sqlite3 Value Error

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related