The book never says that None is "NULL"? I will check. That would be a big omission.
Massimo On Dec 12, 5:24 pm, Lorin Rivers <lriv...@mosasaur.com> wrote: > 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)