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.
