Re: sqlite empty inserts

On Aug 16, 11:20 am, Peter Otten <[EMAIL PROTECTED]> wrote: > sapsi wrote: > > [please don't top-post] > > > > > Thank you for the tip, you're absolutely right.I;m getting an > > exception  that the name must not be null. However, this is some debug > > output > > --- logging.debug(" %s %s %s" %  (

Re: sqlite empty inserts

sapsi wrote: [please don't top-post] > Thank you for the tip, you're absolutely right.I;m getting an > exception that the name must not be null. However, this is some debug > output > --- logging.debug(" %s %s %s" % (vdbname, foldername,where_query)) > OUTPUT: TestVDB test_b title regexp 'tit'

Re: sqlite empty inserts

I forgot to mention that i was creating a view just before this i.e sql="create view %s as %s" % (foldername, query) # self.cursor.execute(sql) self.cursor.execute(sql) Now if i remove this, the insert code works fine. Regards Saptarshi -- http://mail.python.org/mailman/listinfo/pytho

Re: sqlite empty inserts

Hi, Thank you for the tip, you're absolutely right.I;m getting an exception that the name must not be null. However, this is some debug output --- logging.debug(" %s %s %s" % (vdbname, foldername,where_query)) OUTPUT: TestVDB test_b title regexp 'tit' --- print vdbname.__class__, foldername.__cl

Re: sqlite empty inserts

sapsi wrote: > 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, >

sqlite empty inserts

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))