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
