- This code is working, but...
   - is there a better or shorter way to accomplish this.
   

~ thanks for help.
Rob



{{

# QUESTION:
# is there a more direct way of accomplishing this?

# file: userinfo.html  (a web2py view)

# I'm logged in as
# user: jdoe

# this will return first_name and last_name of any OTHER user in 
db.auth_user
# if they exist


# I want to access information on ANOTHER user: jsmith
# jdoe will type in to a form (not shown here):
# jsmith
# to see if they are a user.


# db.auth_user holds:
#  username: jsmith
#  first_name: John
#  last_name: Smith


# just use variable myuser for this example snippet
myuser = 'jsmith'

# attempt to grap the first and last name of user jsmith

first =  db(db.auth_user.username == myuser).select(db.auth_user.first_name
).as_list()
second = db(db.auth_user.username == myuser).select(db.auth_user.last_name).
as_list()

# see if the query returned anything. i.e. test if username is in database
if len(first)>0:
    s1=first[0]['first_name']
    s2 =second[0]['last_name']

    # prints:   John Smith
    = s1 + ' ' + s2
    else:
    = "user not a member of site"
pass

}}



-- 

--- 
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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.


Reply via email to