I expect it will include the NULL... I said different then TRUE I want the rest... I didn't know I had to take care of this...
So I have to write this like that db((db.mytable.id == 1) & (db.mytable.mybool != True) & (db.mytable.mybool == None)).select() Thanks Richard On Wed, Aug 7, 2013 at 5:20 PM, Niphlod <[email protected]> wrote: > what did you expect ? > Any query with a filter (unless IS NOT NULL) doesn't take into account the > NULL value. > It's a pretty standard behaviour in any SQL backend. > > If you need to get all rows with both False AND None values, you should do > > db((db.mytable.id == 1) & ((db.mytable.mybool != True) | > (db.mytable.mybool != None))).select() > > -- > > --- > 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/groups/opt_out. > > > -- --- 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/groups/opt_out.
