max_id = db(db.table).select(db.table.id.max()) and db(db.table.id==max_id).update(field='avariable')
or db(db.table.id.belongs(db(db.table)._select(db.table.id.max())).update(field='avariable') but you should not count on id being sequential. That is not true on GAE and it is not true for other NoSQL which we partially support. You should use a datetime timestemp. On May 28, 3:22 am, Blackpainter <[email protected]> wrote: > Hi all, > > im pretty new to web2py and encountered a little problem. > i need to find the highest ID in my table ( which through other > threads i > already accomplished) and update another field in this entry with an > variable. > (db.table.insert(field=db.table.field.store(request.body,'picture.jpg')) > > i started with: > db.executesql(""" UPDATE table SET field='*variable*' WHERE id=(SELECT > MAX(id) FROM table)""") > > but kinda reached a dead end as its probably not possible to include > my > variable in the executesql command. > The Variable comes from a flash application, which takes a webcam foto > and > accesses a function in web2py. > plz, help, cant help myself :/ > > Your newbie, > Blackpainter
