So Ive got a select request that looks like this: a = db((db.clear.client==req_arg_0) & ((db.clear.Property_Type != 'aa') & (db.clear.Property_Type != 'bb') & (db.clear.Property_Type != 'cc'))).select()
And it works just fine. However, when I do: a = db((db.clear.client==req_arg_0) & (db.clear.Property_Type not in [ 'aa', 'bb', 'cc'])).select() it selects everything where client == req_arg_0 and disregards the second premise....even though I thought these were supposed to be equivalent expressions. I know this is an easy fix, but Im not seeing it.... -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.