The DAL will do the join for you on a reference field. You should be
able to do:
comments = db(db.post_comment.post_id==request.args(0)).select()
for c in comments:
print c.comment_by.username,c.comment
I don't think this works on GAE
On Feb 9, 11:19 pm, minh <[email protected]> wrote:
> Hi,
>
> I have something along the lines of
>
> db.define_table('post',
> ...)
>
> db.define_table('post_comment',
> Field('post_id', db.post),
> Field('comment_by', db.auth_user),
> Field('comment', 'text')
>
> I'm trying to list the comments along with the author's name. However,
> I'm having problems joining the tables. How could I do this with the
> DAL?
>
> Thank you.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
