Thanks for the help. How would you implement a workaround for that 2nd
JOIN case to work on GAE?
On Feb 9, 11:35 pm, mdipierro <mdipie...@cs.depaul.edu> wrote:
> 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" <nat...@freezable.com> 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 <mdn0...@gmail.com> 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 web...@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.
