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)