[web2py] Filtering on NULL values in DAL query

2012-09-05 Thread Yarin
Is this documented anywhere? --

Re: [web2py] Filtering on NULL values in DAL query

2012-09-05 Thread Bruno Rocha
db(db.table.field == None).select() should give you all records with field = NULL db(~db.table.field == None).select() All records where field NULL Is that? --

Re: [web2py] Filtering on NULL values in DAL query

2012-09-05 Thread Marin Pranjić
it is db.table.field != None operator ~ is used for ORDER BY and it maps to DESC. On Wed, Sep 5, 2012 at 7:59 PM, Bruno Rocha rochacbr...@gmail.com wrote: db(~db.table.field == None).select() --

Re: [web2py] Filtering on NULL values in DAL query

2012-09-05 Thread Bruno Rocha
On Wed, Sep 5, 2012 at 3:12 PM, Marin Pranjić marin.pran...@gmail.comwrote: it is db.table.field != None operator ~ is used for ORDER BY and it maps to DESC. Yes, my bad, you are right, but there is one case where ~ is used in query ~db.table.field.belongs(list) and

Re: [web2py] Filtering on NULL values in DAL query

2012-09-05 Thread Yarin
Thanks. Massimo we need this in the docs. On Wednesday, September 5, 2012 2:38:26 PM UTC-4, rochacbruno wrote: On Wed, Sep 5, 2012 at 3:12 PM, Marin Pranjić marin@gmail.comjavascript: wrote: it is db.table.field != None operator ~ is used for ORDER BY and it maps to DESC. Yes, my

Re: [web2py] Filtering on NULL values in DAL query

2012-09-05 Thread Marin Pranjić
Thanks, good to know :) On Wed, Sep 5, 2012 at 8:37 PM, Bruno Rocha rochacbr...@gmail.com wrote: On Wed, Sep 5, 2012 at 3:12 PM, Marin Pranjić marin.pran...@gmail.comwrote: it is db.table.field != None operator ~ is used for ORDER BY and it maps to DESC. Yes, my bad, you are right, but

Re: [web2py] Filtering on NULL values in DAL query

2012-09-05 Thread Marin Pranjić
Db.table.field == None On Sep 5, 2012 6:42 PM, Yarin ykess...@gmail.com wrote: Is this documented anywhere? -- --