Here : https://groups.google.com/d/msg/web2py/hQGyg6fL1Ls/zhxcWg7BsjYJ
Was a type issue... Richard On Thu, Aug 8, 2013 at 3:47 PM, Richard Vézina <[email protected]>wrote: > I have been quite puzzled with .belongs() in the pass... I don't remember > exactly was the cause of my problem at that time, I think it was if I was > passing a list to .belongs() and it was empty. I think I had asking about > that and get a answer from Niphold to... Let me searche that... > > Richard > > > On Thu, Aug 8, 2013 at 3:44 PM, Jonathan Lundell <[email protected]>wrote: > >> On 8 Aug 2013, at 12:12 PM, Niphlod <[email protected]> wrote: >> >> Until now I assumed the problem of @Richard is that if a row has column >> == None, if he queries the table with column != True he expected the NULL >> row to show (because in python None is different from True). >> >> ~db.table.column=False will result in a WHERE NOT column = 'F'. You don't >> get any row holding column == None with that query. >> >> What you said in your post >> >> That would be false for False and true for True and None (NULL) >>> >> >> is what happens in python but not in any db backend, reason why it may >> seem cumbersome to users accustomed to "compare" in python vs in databases. >> >> >> Thanks for this. I've been puzzling over it myself the last couple of >> days. It'd be helpful if your explanation, or at least a summary of it, >> appeared in The Book. >> >> Would .belongs() work as expected (over True/False/None)? >> >> -- >> >> --- >> 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.
