No. db(query).select(*fields,**parameters)
query is just the WHERE. If the query involves more than one table, web2py interprets it as an INNER JOIN. query can be None (or nothing) if fields are specified. If you want a LEFT OUTER JOIN db(query).select(db.table1.ALL,db.table2.ALL,left=db.table2.on(query2)) query2 is the query to be use in the Join. Massimo On Oct 23, 9:24 am, annet <[EMAIL PROTECTED]> wrote: > Denes and Timothy, > > Thanks for answering my question about the [0] thing. > > Denes, > > Adding a closing parenthesis did not solve my problem. > > I am struggling with what's between the db() parenthesis. As far as I > can judge both my JOIN and WHERE clause should be in db(), like > db((JOIN),(WHERE)). As I said the JOIN works, it's the where clause > that causes me trouble. In this query it is of the form (p and q and > r), however, in other queries it is of the form (p and (q or r)), so I > need that to be possible as well. > > Following one of the examples I used '|' in my ORDER BY clause, > however, I want the function to order by ranking first and in case of > equal ranking to order by name, shouldn't the '|' be a '&' then? > > Annet. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
