Thanks, Mladen, that worked, I think I tried that earlier but gave me
an error.
On Aug 22, 8:20 pm, Mladen Milankovic <mml...@gmail.com> wrote:
> 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
-~----------~----~----~----~------~----~------~--~---
