sqlite3 bug?

Tim Chase python.list at tim.thechases.com
Wed Feb 10 19:38:13 EST 2010


dads wrote:
> When the method below is run it raises 'sqlite3.OperationalError: no
> such table: dave'.
> the arguments are ds = a datestamp and w = a string of digits. The
> path of the db is
> C:\sv_zip_test\2006\2006.db and the table is definitely named dave.
> I've run the sql
> in sql manager and it works. Is this a bug?
>
> dbfp = os.path.abspath(os.path.join(archive, year, year + '.db'))
> if os.path.exists(dbfp):
>    con = sqlite3.connect('dbfp')

did you mean

   connect(dbfp)

instead of

   connect('dbfp')

?

-tkc





More information about the Python-list mailing list