python, sqlite3 and two values

Question

How to take two values into sqlite3 ?

v1 = '2011.11.10'
v2 = 10

vv1=(v1,)
vv2=(v2,)


conn = sqlite3.connect('date.db')
c = conn.cursor()
c.execute(" UPDATE archive SET date=? WHERE Id=? ", (vv1,vv2) ) # (vv1,vv2) this is not work, how?
conn.commit()

I know, that probably a simple , but can't find anything on net. Tnx

unutbu · Accepted Answer · 2011-11-10 22:31:37Z

1

v1 = '2011.11.10'
v2 = 10
...
c.execute(" UPDATE archive SET date=? WHERE Id=? ", (v1,v2) )

For cursor.execute, pass a sequence of values, not a sequence of sequence of values.

For cursor.executemany, in contrast, you would want to pass a sequence of sequences.

answered Nov 10, 2011 at 22:31

unutbu

886k197 gold badges1.9k silver badges1.7k bronze badges

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

Collectives™ on Stack Overflow

python, sqlite3 and two values

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