[web2py:15044] Re: KeyError on web2py SQL

he table is prehexisting: > > db.define_table('tblAccounts',,migrate=False) > > Massimo > > On Jan 16, 9:04 am, Erik Telford wrote: > > > I am attempting to connect to a mysql db using the following: > > > def mydb(): > >    db = SQLDB("mysql://u

[web2py:15041] KeyError on web2py SQL

I am attempting to connect to a mysql db using the following: def mydb(): db = SQLDB("mysql://user:passw...@localhost:3306/thedbname") r = db().select(db.tblAccounts.ALL) return r however, I receive this error: KeyError: 'tblAccounts' I am able to make the db connection and I can succ

[web2py:15042] DB connection - invalid Key

I am attempting to connect to a mysql db using the following: def mydb(): db = SQLDB("mysql://etelford:bulabu...@localhost:3306/etelford") r = db().select(db.tblAccounts.ALL) return r however, I receive this error: KeyError: 'tblAccounts' I am able to make the db connection and I c