[web2py] Re: DAL left join problems

2011-07-25 Thread Cliff
I think the answer may be to manually insert the request_tenant field where I want it. I really only want it in the tables that represent objects, not in the many-to-many linking tables. Thanks, Richard. I got it working. The table structure is really pretty simple. It's lifted from a working P

Re: [web2py] Re: DAL left join problems

2011-07-25 Thread Richard Vézina
Could you post your models... You can make view at DB level and define a web2py model of your view... It help to get things done sometime and you can come back later and build web2py query correctly. Richard On Mon, Jul 25, 2011 at 1:45 PM, Cliff wrote: > Found it, but don't know what to do ab

[web2py] Re: DAL left join problems

2011-07-25 Thread Cliff
Found it, but don't know what to do about it. Here is what the DAL is spitting out: SELECT auth_user.first_name, training_requirements.course_id FROM auth_user LEFT JOIN training_requirements ON (training_requirements.user_id = auth_user.id) WHERE (((training_requirements.course_id = 8) OR (trai