As far as I can tell, the only place null is mentioned in the DAL page is in the definition of tables.
On Dec 12, 2010, at 17:35 , mdipierro wrote: > 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) -- Lorin Rivers Mosasaur: Killer Technical Marketing <http://www.mosasaur.com> <mailto:lriv...@mosasaur.com> 512/203.3198 (m)