Forgot to mention : web2py 2.4.7 postgres 9.1 under ubuntu 12.04 server 64 bit...
Richard On Wed, Aug 7, 2013 at 5:00 PM, Richard <[email protected]> wrote: > Hello, > > Found this not working : > > db((db.mytable.id == 1) & (db.mytable.mybool != True).select() > > That translate as : > SELECT * FROM mytable WHERE mytable.id = 1 AND mytable.mybool <> 'T' > > NO RECORD, BUT THERE IS A RECORD > > If i change the select like this : > SELECT * FROM mytable WHERE mytable.id = 1 AND mytable.mybool IS NOT TRUE > > I get my record. > > The issue seems to occure only when the "mybool" is NULL other then that > (TRUE or FALSE) I got my record... > > Thanks > > Richard > > > -- > > --- > 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.
