[web2py] Re: DB query help

2010-02-10 Thread minh
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

Re: [web2py] Re: DB query help

2010-02-10 Thread Thadeus Burgess
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,

[web2py] Re: DB query help

2010-02-09 Thread mr.freeze
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,

[web2py] Re: DB query help

2010-02-09 Thread mdipierro
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