[web2py] Re: DAL Join

[contact . urbangatherer]

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" 
, line 
124, in 
  File "/home/www-data/web2py/gluon/globals.py", line 372, in 
self._caller = lambda f: f()
  File "/home/www-data/web2py/applications/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" 
, 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, contact.ur...@gmail.comwrote:
>>
>> 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 web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[web2py] DAL Join

[contact . urbangatherer]

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

[web2py] Access the database for current user

[contact . urbangatherer]

I am new to web2py and am having a problem understanding / finding an 
answer to the  following.
I have extended the Auth database in Web2py to include the following fields:
street
city
country

how would i read the street, city, country of the currently logged on user 
and apply it look up a geocode.

So far i have the following code in controller but cant seem to find the 
code to reference the database correctly.

def geo():
 from gluon.tools import geocode
 user= auth.user.id #gives me the user id 
street = db.auth_user??
city = 
country = 
 (latitude, longitude) = geocode('street,city,country')
 return dict(latitude=latitude,longitude=longitude)

-- 

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