No kidding. That should be called out in The Book.

On Dec 12, 2010, at 17:14 , mdipierro wrote:

> db(db.mytable.myfield!=None).select()
> 
> On Dec 12, 5:02 pm, Lorin Rivers <lriv...@mosasaur.com> wrote:
>> Sometimes in the app I'm working on the default values aren't set in a 
>> column (for reasons outside of my control).
>> 
>> So, instead of using the default value as a filter, I need to also test for 
>> null.
>> 
>> How do I do that in the DAL?
>> 
>> In other words, "select * from table where field is not NULL;"
>> 
>> --
>> Lorin Rivers
>> Mosasaur: Killer Technical Marketing <http://www.mosasaur.com>
>> <mailto:lriv...@mosasaur.com>
>> 512/203.3198 (m)

-- 
Lorin Rivers
Mosasaur: Killer Technical Marketing <http://www.mosasaur.com>
<mailto:lriv...@mosasaur.com>
512/203.3198 (m)


Reply via email to