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)