Hi,
Please help me with following.

I have created the api  I am passing company_name(string) to it, for select 
I am comparing reference Id to name.
I get the error 
<type 'exceptions.ValueError'> invalid literal for long() with base 10: 
'cadence'
at db.company_user.company == company_name
I actually don't know how to compare reference id to name.
 

@request.restful()
def company_user():
    def GET(company_name, role=None):
        company_user_ids = [u['auth_user'] for u in db(db.company_user.company 
== company_name
                                                      ).select()]
        query = db.auth_user.id.belongs(company_user_ids)
        auth_users = db(query).select(db.auth_user.ALL)
        return json(auth_users)
    return locals()


Thanks.

-- 
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.

Reply via email to