You have your queries all wrong. Can you share your code? You should use the python bitwise operators not the words. Also, why are you using assignment when you should be testing for equality?
On Thursday, June 12, 2014 2:35:25 PM UTC-7, Vincent wrote: > > How would one go about doing the equivalent of > A and (B or C) > in the grid or smartgrid search? > Tried reading the source but got lost. > > Given > db.person.firstname > db.person.lastname > > this fails as an invalid query: > person.firstname = "John" and (person.lastname = "Smith" or > person.lastname = "Williams") > > Boolean precedence also does not seem to be implemented (and before or) as > this doesn't return the expected results: > person.firstname = "John" and person.lastname = "Smith" or > person.firstname = "John" and person.lastname = "Williams" > > Any suggestions? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
