yes - it's all pretty straight forward. On Thu, Oct 8, 2009 at 1:02 PM, Carl <[email protected]> wrote:
> > Thanks! Nice and straightforward. > > On Thursday, October 8, 2009, mdipierro <[email protected]> wrote: > > > > rows=db(db.auth_user.id>0).select(db.auth_user.email) > Realize that the expression in the db() portion is like the WHERE clause of an SQL query (what you search on), so this one selects (effectively) all of the table (since id's start at 1); To get a specific id, you change this part - e.g. db(db.auth_user.id == my_desired_id).select(db.auth_user.email) --- that select clause picks the columns of the table to return. > > > > On Oct 8, 12:24 pm, Carl <[email protected]> wrote: > >> hi, > >> > >> I've got a user id which I'd like to use to look-up that user's email > >> address. > >> I'm using Auth to create all user accounts. > >> > >> I need to present a set of user email's to the currently logged in > >> user. > >> > >> thanks > > > > > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
