Massimo,
I still get the error:
Traceback (most recent call last):
File "/home/daniel/web2py/gluon/restricted.py", line 98, in
restricted
exec ccode in environment
File "/home/daniel/web2py/applications/community/controllers/
forum.py", line 9, in <module>
File "/home/daniel/web2py/gluon/globals.py", line 75, in <lambda>
self._caller = lambda f: f()
File "/home/daniel/web2py/applications/community/controllers/
forum.py", line 5, in index
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)
File "/home/daniel/web2py/gluon/sql.py", line 1902, in select
r = response(query)
File "/home/daniel/web2py/gluon/sql.py", line 1897, in response
self._db._execute(query)
File "/home/daniel/web2py/gluon/sql.py", line 634, in <lambda>
**b)
File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line
166, in execute
self.errorhandler(self, exc, value)
File "/var/lib/python-support/python2.5/MySQLdb/connections.py",
line 35, in defaulterrorhandler
raise errorclass, errorvalue
OperationalError: (1066, "Not unique table/alias: 'mb_posts'")
forum.py:
def index():
rows = (db.mb_posts.board_id==db.mb_boards.id)&
(db.mb_posts.reply_to==0)
mb_posts2 = db.mb_posts.with_alias("mb_posts2")
rows2 = (db.mb_posts2.board_id==db.mb_boards.id)
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)
response._vars=response._caller(index)
On Apr 2, 9:08 am, mdipierro <mdipie...@cs.depaul.edu> wrote:
> should be
>
> def index():
> rows = (db.mb_posts.board_id==db.mb_boards.id)&
> (db.mb_posts.reply_to==0)
> mb_posts2 = db.mb_posts.with_alias("mb_posts2")
> rows2 = (db.mb_posts2.board_id==db.mb_boards.id)
> 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)
>
> On Apr 1, 11:13 pm, TheDude <officed...@gmail.com> wrote:
>
> > 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 web2py@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
-~----------~----~----~----~------~----~------~--~---
