Hi there,
I encounter a not-so-intuitive behavior when search in boolean field,
named
Giving the definition:
SQLField('special', 'boolean', default=False)
And bear in mind that there are THREE kinds of value in this field:
True, False, and ""(None)!
When I search:
db(db.Orders.special==True).select()
it works like a charm.
When I search:
db(db.Orders.special!=True).select()
it equals to:
db(db.Orders.special==False).select()
but not equals to:
db((db.Orders.special==False)|(db.Orders.special==None)).select()
Do I have to use the last form to select all non-True records? Is this
an intended design, or a unexpected flaw?
Thanks in advance.
Iceberg
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
