rows = db(db.post.id > 0).select()
for row in rows:
comments = db(db.comment.post_id == row.id).select()
-Thadeus
On Wed, Feb 10, 2010 at 11:58 AM, minh <mdn0...@gmail.com> wrote:
> 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.
>
>
--
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.
