Then it must be a bug, I still get an error
_execute build\bdist.win32\egg\sqlalchemy\engine\base.py 602
"SQLError: (ProgrammingError) column ""user.id"" must appear in the
GROUP BY clause or be used in an aggregate function
On Jun 27, 9:09 pm, Andreas Jung <[EMAIL PROTECTED]> wrote:
> --On 27. Juni 2007 12:00:13 -0700 voltron <[EMAIL PROTECTED]> wrote:
>
>
>
> > I´m guessing a bit because I still could not find the group_by entry
> > in the docs
>
> > This works:
> > user.select(links.c.id> 3, order_by=[user.c.id]).execute()
>
> > but this does not
> > user.select(links.c.id> 3,group_by=[user.c.dept]).execute()
>
> > What should be the right syntax?
>
> Works for me:
>
> for row in session.query(am).select(am.c.hidx=='HI1561203',
> group_by=[am.c.hidx]):
> print row.hidx, row.versionsnr
>
> -aj
>
> application_pgp-signature_part
> 1KDownload
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
