Thank you so much, everything is working now =). my deepest thanks, Blackpainter
On 29 Mai, 01:50, Massimo Di Pierro <[email protected]> wrote: > My mistake: > > max_id = db(db.table).select(db.table.id.max()).first() > [db.table.id.max()] > and > db(db.table.id==max_id).update(field='avariable') > > On May 28, 10:23 am, Massimo Di Pierro <[email protected]> > wrote: > > > 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(fiel > > d='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 > >
