btw... with the latest version you "mdipierro/develop" you can also do
$ python web2py.py -S atest
>>> db=SQLDB()
>>> db.define_table('a',SQLField('b','integer'),SQLField('c','integer'))
>>> db.a.insert(b=1,c=2)
1
>>> db.a.insert(b=2,c=1)
2
>>> db.a.insert(b=2,c=2)
3
>>> for row in db(db.a.b+2==db.a.c+1).select(): print row.id
1
>>> for row in db(db.a.b+2==(db.a.c+1)*2).select(): print row.id
2
>>> db(db.a.b==1).update(b=(db.a.b+db.a.c+1)*2)
>>> for row in db(db.a.id==1).select(): print row.b
8
Massimo
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to web2py@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
