[web2py] Re: DB query help
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.
Re: [web2py] Re: DB query help
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.
[web2py] Re: DB query help
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.
[web2py] Re: DB query help
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.
