I think that this is wrong : upload = db(db.lecture_items.id==uidi). select().first()
try not use upload var at first, do this instead : db(db.lecture_items.id==uidi).update(fileetag='%s' % request.vars.etag) If still not working, you should investigate if "uidi" is really the id of the record you attempt to update. Also, you don't need to select a record to update it, just precise which one in the "where clause" : db.lecture_items.id==uidi is equivalent to the where clause in SQL : http://web2py.com/books/default/chapter/29/6?search=update#count,-isempty,-delete,-update Richard On Wed, May 16, 2012 at 9:51 AM, lucas <sjluk...@gmail.com> wrote: > hello one and all, > > trying to update, but not updating. here is my code: > > db.lecture_items.fileetag.writable = True > upload = db(db.lecture_items.id==uidi).select().first() > upload.update(fileetag='%s' % request.vars.etag) > db.commit() > > i even threw in the commit and i have verified that request.vars.etag is a > valid string and that upload.fileetag is getting filled with that value. > but when i check it using psql for postgresql, the value is empty or null. > here is the field structure: > > Field('fileetag', length=128, default='', writable=False, > readable=False), > > thank you in advance and have a great day. lucas > >
