Re: SQLite3 trapping OperationalError

2007-03-10 Thread paul
jim-on-linux schrieb: > pyhelp, > > I set up a table in SQLite3. > > While running other modules I want to know if a > table exists. > > SQL has a command "List Tables" but I don't think > SQLlite3 has this command. I think "list tables" is a mysqlism > > I've tried >cursor.execute("se

Re: SQLite3 trapping OperationalError

2007-03-09 Thread jim-on-linux
On Friday 09 March 2007 13:10, Jerry Hill wrote: > On 3/9/07, jim-on-linux <[EMAIL PROTECTED]> wrote: > > However python 2.5, > > except OperationalError: > > responds with > > "OperationalError" is not defined. > > I believe that needs to be spelled > except sqlite3.OperationalError: > do_som

Re: SQLite3 trapping OperationalError

2007-03-09 Thread Jerry Hill
On 3/9/07, jim-on-linux <[EMAIL PROTECTED]> wrote: > However python 2.5, > except OperationalError: > responds with > "OperationalError" is not defined. I believe that needs to be spelled except sqlite3.OperationalError: do_something() -- Jerry -- http://mail.python.org/mailman/listinfo/pyt

SQLite3 trapping OperationalError

2007-03-09 Thread jim-on-linux
pyhelp, I set up a table in SQLite3. While running other modules I want to know if a table exists. SQL has a command "List Tables" but I don't think SQLlite3 has this command. I've tried cursor.execute("select * from debtor where key is not null ") The table debtor does not exist so