for the same exact reason.
NOT field = True
in t-sql means just FALSE, not FALSE and NULL
On Monday, March 9, 2015 at 2:37:46 PM UTC+1, Dmitry Ermolaev wrote:
I use negate - why this not worked?
воскресенье, 8 марта 2015 г., 23:15:49 UTC+3 пользователь Niphlod написал:
booleans in
I use negate - why this not worked?
воскресенье, 8 марта 2015 г., 23:15:49 UTC+3 пользователь Niphlod написал:
booleans in T-SQL are not treated the same way as python. in T-SQL,
NULL values are neither True or False, they are just NULL.
So, if you want closed either None or False, you
but
db((db.progs.promo==True)).select():
is work!
понедельник, 9 марта 2015 г., 16:58:26 UTC+3 пользователь Niphlod написал:
for the same exact reason.
NOT field = True
in t-sql means just FALSE, not FALSE and NULL
On Monday, March 9, 2015 at 2:37:46 PM UTC+1, Dmitry Ermolaev wrote:
not work:
for pr in db((db.progs.promo.belongs((None, False)))
(db.progs.closed.belongs((None, False.select():
work:
for pr in db(db.progs).select():
if pr.promo or pr.closed: continue
понедельник, 9 марта 2015 г., 16:58:26 UTC+3 пользователь Niphlod написал:
with that query you get None or False for both promo and closed. What do
you want ?
On Monday, March 9, 2015 at 8:27:27 PM UTC+1, Dmitry Ermolaev wrote:
not work:
for pr in db((db.progs.promo.belongs((None, False)))
(db.progs.closed.belongs((None, False.select():
work:
booleans in T-SQL are not treated the same way as python. in T-SQL,
NULL values are neither True or False, they are just NULL.
So, if you want closed either None or False, you should do
((db.progs.closed == None) | (db.progs.closed == False))
one shortcut to it would be
6 matches
Mail list logo