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 -~----------~----~----~----~------~----~------~--~---
