Re: [web2py] Re: dal exception occurs when running on gae

2011-03-12 Thread zhao peng
thanks. On Sat, Mar 12, 2011 at 10:07 PM, Massimo Di Pierro massimo.dipie...@gmail.com wrote: It is not a web2py bug. web2py it is just telling you that GAE cannot do this, because there are no expressions on GAE. Instead of this: db(db.user.id == session.user_id).update(post_num =  

[web2py] is there a function to increase a sql field

2011-03-05 Thread zhao peng
Hi, I want to know is there a function to add 1 to a sql field, or else I have to select to get the value of the field and then add 1 to the value, then update the field. Thanks.

Re: [web2py] is there a function to increase a sql field

2011-03-05 Thread zhao peng
Thanks a lot. It works. On Sun, Mar 6, 2011 at 1:13 AM, Vasile Ermicioi elff...@gmail.com wrote: update tabl1 set field1=field1+1 where your_condition db(some dal condtion like: db.table1.id0).update(field1=db.table1.field1+1)