sqlite empty inserts
sapsi
saptarshi.guha at gmail.com
Sat Aug 16 01:38:38 EDT 2008
Hello,
I created a table like:
create table __saved_query__ (vdb_name text , query_table_name text
PRIMARY KEY, query text)
and then I insert as follows
self.cursor.execute( "insert into __saved_query__(vdb_name,
query_table_name, query) values (?,?,?)", (vdbname,
foldername,where_query))
self.conn.commit()
Now for some reason, the first insert works, but thereafter all
inserts result in empty rows
e.g
sqlite> select * from __saved_query__;
TestVDB|test_b|title regexp 'boo'
||
||
The last two rows are from the 2nd and 3rd inserts. The values i;m
inserting are non null.
Any ideas?
Thank you for your time
Saptarshi
More information about the Python-list
mailing list