the syntax is db(q).update(fieldname=something)
you instead are trying to do db(q).update(tablename.fieldname=something) On Sunday, February 1, 2015 at 8:54:21 PM UTC+1, Alex Glaros wrote: > > anyone see why this update line doesn't work? > > db(db.auth_user.id == auth.user_id).update(auth_user.last_logged_in= > request.now) > > raises this error: > > <type 'exceptions.SyntaxError'> keyword can't be an expression > > but this works in the Database Administration (appadmin) with table > auth_user > > last_logged_in = request.now > > and this other unrelated update works: > > db(db.InternalMessage.id == this_message.id).update(dateTimeMessageRead= > request.now) > > thanks > > Alex Glaros > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
