[sqlalchemy] Re: Making msg board

2007-03-15 Thread tml
Hi svilen, thanks. I have that query working now. On Mar 15, 9:10 am, svilen <[EMAIL PROTECTED]> wrote: > use table.alias() for one of the roles - or for both. > > > Hi, > > > I doing a msg board with nested sets as descrived on > >http://dev.mysql.com/tech-resources/articles/hierarchical-data.h

[sqlalchemy] Re: Making msg board

2007-03-15 Thread Ram
Hi, that worked great! thanks :) - tml On Mar 15, 9:10 am, svilen <[EMAIL PROTECTED]> wrote: > use table.alias() for one of the roles - or for both. > > > Hi, > > > I doing a msg board with nested sets as descrived on > >http://dev.mysql.com/tech-resources/articles/hierarchical-data.html > > >

[sqlalchemy] Re: Making msg board

2007-03-15 Thread svilen
use table.alias() for one of the roles - or for both. > Hi, > > I doing a msg board with nested sets as descrived on > http://dev.mysql.com/tech-resources/articles/hierarchical-data.html > > I'm not sure how to do a statement like this in sqlalchemy: > > SELECT node.id, node.topic, node.content >