Yes this:
comments = db(db.post_comment.post_id==request.args(0)).select()
for c in comments:
print c.comment_by.username,c.comment
works on GAE but this is not a JOIN.
This a join:
comments = db(db.post_comment.post_id==db.post.id)==.select()
for c in comments:
print c.post.content,c.post_comment.comment
On Feb 9, 11:30 pm, "mr.freeze" <[email protected]> wrote:
> 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.
