Looks like you copied the code incorrectly. It should be auth.user.id or auth.user_id, not db.auth_user.id.
Anthony On Thursday, January 10, 2013 2:02:47 AM UTC-5, b00m_chef wrote: > I found why it wasn't working. It is because the db was set to migrate=False. > > > However, the code doesn't work. I still get a listing of all Collars from all > owners. > > > > > On Wednesday, January 9, 2013 10:25:25 PM UTC-8, b00m_chef wrote:I get an > error on loading the new puppy page for first time. I had to change your code > as it didn't work to the following: > > > requires=IS_IN_DB(db(db.owner.user == db.auth_user.id), 'owner.id', > '%(name)s') > > > Now I get an error: > <class 'sqlite3.OperationalError'> no such table: owner > > > However, the table IS there...no idea what's causing this... > > > > > Thanks for the help!! > > > On Wednesday, January 9, 2013 9:40:18 PM UTC-8, rochacbruno wrote: > > On Thu, Jan 10, 2013 at 3:09 AM, b00m_chef <[email protected]> wrote: > > > > requires=IS_IN_DB(db(db.owner.user == auth.user.id), 'owner.id', '%(name)s') --
