Re: [web2py] Clearing Database Tables

2010-06-02 Thread Thadeus Burgess
And for a given field... db(db.table.id > 0).update(field = None) -- Thadeus On Wed, Jun 2, 2010 at 2:04 PM, Thadeus Burgess wrote: > db.table.truncate() > > -- > Thadeus > > > > > > On Wed, Jun 2, 2010 at 1:05 PM, Vasile Ermicioi wrote: >> db(db.table.id > 0).delete() >> no sure what you

Re: [web2py] Clearing Database Tables

2010-06-02 Thread Thadeus Burgess
db.table.truncate() -- Thadeus On Wed, Jun 2, 2010 at 1:05 PM, Vasile Ermicioi wrote: > db(db.table.id > 0).delete() > no sure what you mean by entries in a given field > >

Re: [web2py] Clearing Database Tables

2010-06-02 Thread Vasile Ermicioi
db(db.table.id > 0).delete() no sure what you mean by entries in a given field

[web2py] Clearing Database Tables

2010-06-02 Thread Aaron Crowe
What would the code be to delete either all entries in a database table or all entries in a given field within that table?