> row.b='xxx' > row.update_record() ### no arguments! nice
On Oct 29, 2:32 am, mdipierro <[email protected]> wrote: > You are right and it is still changing. Correction on previous post: > > ### given: > db=DAL('sqlite://storage') > db.define_table('a',Field('b')) > db.a.insert(b='aaa') > db.a.insert(b='aab') > db.a.insert(b='abb') > db.a.insert(b='bbb') > row=db(db.a.id>0).select().first() > > ### you can do, as before > print row.b > row.update_record(b='yyy') > > ### or as you used to do in Django (NEW to web2py) > row.b='xxx' > row.update_record() ### no arguments! > print row,b > > ### you can now also filter and sort at the web2py level searsh > results (thanks Mr. Freeze) (NEW) > rows=db(db.a.id>0).select().filter(lambda row: row.b>0).sort(lambda > row: row.b.upper()) > for row in rows: print row.b > > On Oct 28, 10:29 am, Alex Fanjul <[email protected]> wrote: > > > We will have to document this 'database stuffs' very well because I'm > > lost with so many new features. The best documentation for me is finally > > an example like this (maybe in more real context). > > Thanks for new features Massimo, > > Alex F > > > El 28/10/2009 16:08, mdipierro escribió: > > > > ### given: > > > db=DAL('sqlite://storage') > > > db.define_table('a',Field('b')) > > > db.a.insert(b='aaa') > > > db.a.insert(b='aab') > > > db.a.insert(b='abb') > > > db.a.insert(b='bbb') > > > row=db(db.a.id>0).select().first() > > > > ### you can do, as before > > > print row.b > > > row.update_record(b='yyy') > > > > ### or as you used to do in Django (NEW to web2py) > > > row.b='xxx' > > > row.save > > > () > > > print row,b > > > > ### you can now also filter and sort at the web2py level searsh > > > results (thanks Mr. Freeze) (NEW) > > > rows=db(db.a.id>0).select().filter(lambda row: row.b>0).sort(lambda > > > row: row.b.upper()) > > > for row in rows: print row.b > > > -- > > Alejandro Fanjul Fdez. > > [email protected] > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
