def index():
rows = (db.mb_posts.board_id==db.mb_boards.id)&
(db.mb_posts.reply_to==0)
rows2 = (db.mb_posts.board_id==db.mb_boards.id)
mb_posts2 = db.mb_posts.with_alias("mb_posts2")
query = db().select(db.mb_boards.ALL, db.mb_posts.id.count(),
db.mb_posts2.id.count(), left=(db.mb_posts.on(rows),db.mb_posts2.on
(rows2)), groupby=db.mb_boards.id)
return dict(query=query)
gives me
OperationalError: (1066, "Not unique table/alias: 'mb_posts'")
However, should mb_posts2 show itself as LEFT JOIN mb_posts AS
mb_posts2 ?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" 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
-~----------~----~----~----~------~----~------~--~---
