[web2py] DAL Join

2014-02-19 Thread 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

[web2py] Re: DAL Join

2014-02-19 Thread 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

[web2py] Access the database for current user

2013-03-06 Thread 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