[web2py] Re: Dynamically adding items to search for...

2010-10-22 Thread weheh
Very cool. Didn't know that. Is it in the doc? Makes incrementally refining a search much easier. On Oct 22, 2:48 pm, Thadeus Burgess thade...@thadeusb.com wrote: So when you call the DAL object (in this case db) it makes and SQLObject which holds information about the current SQL. Those

Re: [web2py] Re: Dynamically adding items to search for...

2010-10-22 Thread Thadeus Burgess
The only problem is the join syntax with the DAL. The DAL expects you to pass the join alongside .select(). Thats a problem if you need to have multiple FULL OUTER JOINS for example. Say your looking for people who have an open invoice and have not paid within 90 days and they have an appointment