If you specifically want the username from the auth_user table: db(db.auth_user.id==id).select().first().username
or the shortcut version: db.auth_user[id].username If you want to use the 'format' attribute of the auth_user table (which I think defaults to '%(first_name) %(last_name) (%(id))', you can do: db.auth_user._format % db.auth_user[id] That assumes the 'format' attribute is a string (which the default is) and not a lambda function. Anthony On Thursday, November 3, 2011 4:08:19 PM UTC-4, Bianca Cadaveri wrote: > > Hello, > > I have a number representing somebody in auth_user. How can I get the > username back ? db.auth_user.id.represent(this_number) does not work. > Can somebody please help me ? > > Thank you, > BC
