On Jul 21, 2008, at 7:19 AM, jrpfinch wrote:
> > Hi > > What is the most elegant way of performing a SELECT DISTINCT on a > single column at the ORM level on SQLAlchemy 0.4.6? > > It looks like you can do > q=session.query(Order.support_manager).distinct() in the beta > version. This is not supported in 0.4.6 though. > > Thanks in advance > 0.4's Query doesn't do just single columns so in 0.4 you'd have to use a select() construct. If you use the Session's execute() method it will execute within the context of the Session's current transaction, if any. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---