sqlite error?

John Salerno johnjsal at NOSPAMgmail.com
Tue Nov 7 09:45:40 EST 2006


Frank Millman wrote:

> Definitely not. You could have a sql command like this -
> 
> cur.execute("UPDATE table SET col1 = ?, col2 = ? WHERE col3 = ? AND
> col4 = ?",(1,2,3,4))
> 
> The parameters could be scattered throughout the command. Therefore the
> substitution is one-for-one from left to right using the values in the
> tuple.
>

Thanks! The example I was looking at in the docs didn't use parentheses, 
but I also didn't connect that with the fact that it was only using a 
one-tuple! :)



More information about the Python-list mailing list