I tried both suggestions by yourself and the suggestion by Anthony.
They all return a dictionary as before but my i am still getting the
attribute error.
may be it is something i am doing ?
Here is the error output if it helps
Traceback (most recent call last):
File "/home/www-data/web2py/gluon/restricted.py", line 217, in restricted
exec ccode in environment
File "/home/www-data/web2py/applications/init/controllers/api.py"
<https://urban-gatherer.ca/admin/default/edit/init/controllers/api.py>, line
124, in <module>
File "/home/www-data/web2py/gluon/globals.py", line 372, in <lambda>
self._caller = lambda f: f()
File "/home/www-data/web2py/applications/init/controllers/api.py"
<https://urban-gatherer.ca/admin/default/edit/init/controllers/api.py>, line 8,
in call
return service()
File "/home/www-data/web2py/gluon/tools.py", line 4915, in __call__
return self.serve_json(request.args[1:])
File "/home/www-data/web2py/gluon/tools.py", line 4603, in serve_json
s = universal_caller(self.json_procedures[args[0]], *args[1:], **d)
File "/home/www-data/web2py/gluon/tools.py", line 4274, in universal_caller
return f(**arg_dict)
File "/home/www-data/web2py/applications/init/controllers/api.py"
<https://urban-gatherer.ca/admin/default/edit/init/controllers/api.py>, line
117, in news
company = row.auth_user.company_name
AttributeError: 'NoneType' object has no attribute 'auth_user'
On Wednesday, February 19, 2014 10:15:16 PM UTC-8, Massimo Di Pierro wrote:
>
> Should be
>
> rows =
> db(db.weets.posted_by==user).select(join=db.auth_user.on(db.weets.posted_by==
> db.auth_user.id))
> row = rows.first()
> print row.auth_user.name
>
> Does it work?
>
> Also try (should be the same):
>
> rows = db(db.weets.posted_by==user)(db.weets.posted_by==db.auth_user.id).
> select()
> row = rows.first()
> print row.auth_user.name
>
>
>
>
> On Wednesday, 19 February 2014 23:18:33 UTC-6, [email protected]:
>>
>> Hi,
>> Maybe a stupid question but here goes.
>>
>> I am trying to do the following join.
>>
>> row =
>> db(db.weets.posted_by==user).select(join=db.auth_user.on(db.weets.posted_by==
>> db.auth_user.id))
>>
>> its seems to work and row does return.
>> The example in the book then shows you can use attributes but when i try:
>>
>> row.auth_user.name
>>
>> or other field it says no attribute auth_user.
>>
>> i am not sure why this is?
>>
>
--
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/groups/opt_out.
