Hello, I am new to web2py and found it quite impressive. I have one question though: How do you do OR? ex/
db((db.friends.user1 == session.email | db.friends.user2 == session.email)).select() I want to select to get all entries where user1 is email or user2 is email but it gives me TypeError: unsupported operand type(s) for |: 'str' and 'SQLField'. I tried OR but that doesn't work by python's definition of OR and will only run the first part. Is there a clever way to do this? Which is better: * Make a big select and just run through it to find where user1 or user2 is email * make 2 query calls and append them to array NOTE: I am testing web2py on GAE. Thanks! WK --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
