[Tutor] Need help with sqlite3 in python

Jim Byrnes jf_byrnes at comcast.net
Sun Feb 17 20:47:04 CET 2013

On 02/17/2013 12:31 PM, Alan Gauld wrote:
> On 17/02/13 16:50, Jim Byrnes wrote:
>>      cur.execute("INSERT INTO pwds VALUES ('WebSites', 'xMe', 'me',
>> 'you', 'here', 'there')")
>> When this code is run, done prints in the terminal, there is no error
> Can you do selects properly?
> Can you extract data put in manually? That would prove the connection
> from Python to SQLite was working...

Thank you Alan.  Your question led me to the solution. So many times it 
is dumb little mistakes that trip you up. I had moved a copy of the db 
into the directory I was developing in but was inserting in  the working 
copy.  The insertions were there I was just looking at the wrong db with 

> Usually when I get errors like that its because the values do not match
> the number of fields/types in the table definition, but if the manual
> sql works with the same query that shouldn't be the issue so I'd suspect
> the connection...

Regards,  Jim

More information about the Tutor mailing list