[web2py] Re: query to match if boolean field is not True
On Sunday, 11 February 2018 05:52:44 UTC+1, Massimo Di Pierro wrote: > > I would expect that too but it is not a web2py issue. It is a database > issue. web2py simply translate those in > Hi Massimo, thank you for explanation! David -- 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/d/optout.
[web2py] Re: query to match if boolean field is not True
I would expect that too but it is not a web2py issue. It is a database issue. web2py simply translate those in NOT mytable.boolean_field = 'T' On Tuesday, 6 February 2018 17:32:44 UTC-6, David Zejda wrote: > > Hi :) > > Intuitively I would expect that these queries are equivalent ways to match > if boolean_field is not True: > > ~(db.mytable.boolean_field == True) > > (db.mytable.boolean_field != True) > > ((db.mytable.boolean_field == None) | (db.mytable.boolean_field == False)) > > But only the last one works as expected. > > David > -- 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/d/optout.