Hi.
When you use multiple tables in a query, it return DALStorage object in
DALStorage object for each table you requested. Simpler every row object is a
dict which contains dict object for each table.
try:
{{for review in reviews:}}
<b>{{=review.reviews.headline}}</b>: {{=review.users.username}}
{{pass}}
regards
mmlado
On Saturday 22 August 2009 12:09:18 tititi wrote:
> Hi, I'm testing a similiar join query but not getting success in
> extracting the dictionary
>
> r = db.reviews
> u = db.users
> query = ((db.reviews.id==request.args[0]) & (db.users.id==1))
> left= (r.on(u.id==r.user_id))
> reviews=db(query).select
> (r.headline,r.article,u.username,left=left, orderby=r.date_added)
> return(reviews=reviews)
>
> On the view.html
>
> {{for review in reviews:}}
> <b>{{=review.headline}}</b>: {{=review.username}}
> {{pass}}
>
> I'm getting this error: KeyError: 'headline'
>
> Am I missing something?
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
