[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

On 9/11/07, Lukasz Szybalski <[EMAIL PROTECTED]> wrote: > > > > > Hi, > > > > > > > > > > >And if I wanted to select a year and group by year? > > > > > >"select User.Year from User group by User.Year" > > > > > > db.execute(select([User.Year]) ??? > > > > > > > > > > > > > > > > > Have a look at

[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

> > > > Hi, > > > > > > > > >And if I wanted to select a year and group by year? > > > > >"select User.Year from User group by User.Year" > > > > > db.execute(select([User.Year]) ??? > > > > > > > > > > > > > > Have a look at http://www.sqlalchemy.org/docs/04/sqlexpression.html > > > > > > > Ok. >

[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

On 9/10/07, Roger Demetrescu <[EMAIL PROTECTED]> wrote: > > On 9/8/07, Lukasz Szybalski <[EMAIL PROTECTED]> wrote: > > > > On 9/7/07, Paul Johnston <[EMAIL PROTECTED]> wrote: > > > > > > Hi, > > > > > > >And if I wanted to select a year and group by year? > > > >"select User.Year from User group b

[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

On 9/8/07, Lukasz Szybalski <[EMAIL PROTECTED]> wrote: > > On 9/7/07, Paul Johnston <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > >And if I wanted to select a year and group by year? > > >"select User.Year from User group by User.Year" > > > db.execute(select([User.Year]) ??? > > > > > > > > Have

[sqlalchemy] Re: sqlalchemy with turbogears and assign_mapper: group_by

On 9/7/07, Paul Johnston <[EMAIL PROTECTED]> wrote: > > Hi, > > >And if I wanted to select a year and group by year? > >"select User.Year from User group by User.Year" > > db.execute(select([User.Year]) ??? > > > > > Have a look at http://www.sqlalchemy.org/docs/04/sqlexpression.html > Ok. Based o