Re: [web2py] Neither suggestion worked...

2012-09-23 Thread Bill Thayer
Hi Richard, Sorry for not getting back to this right away. Had so much to do on this project this problem was burning valuable time. My first early release is this Thursday. From before, I did post the code exactly. I'll probably try your shell commands after Friday. Then I'll keep you posted.

Re: [web2py] Neither suggestion worked...

2012-08-28 Thread Richard Vézina
To see what the set return : print db((~db.trainer.id.belongs(db()._select(db.dogs.trainer When you will be into the web2py shell. Richard On Tue, Aug 28, 2012 at 10:22 AM, Richard Vézina < ml.richard.vez...@gmail.com> wrote: > Hi Bill, > > Did you try you set into the web2py shell to see

Re: [web2py] Neither suggestion worked...

2012-08-28 Thread Richard Vézina
Hi Bill, Did you try you set into the web2py shell to see if it returns something? I usually try my query in a terminal web2py shell to make sure my query are good before waisting time in navigator reloading page. Here how you can start a web2py shell : cd into the web2py folder Than : python

[web2py] Neither suggestion worked...

2012-08-27 Thread Bill Thayer
...no trainers are being returned. I even tried moving unassignedtrainers = (~db.trainer.id.belongs(db()._select(db.dogs.trainer))) db.dogs.trainer.requires = IS_IN_DB(db(unassignedtrainers), 'trainer.id', '%(name)s',zero=T('choose one')) to the controller. No luck. The drop down boxes do not