diez you have been of great help
my team thanks you very much, you have solved a great mystery for us :) rotem On Mar 17, 2:42 pm, "Diez B. Roggisch" <[email protected]> wrote: > On Wednesday 17 March 2010 11:34:30 Rotem Tamir wrote: > > > Sorry i didn't understand the example > > > i want to select a distinct list of dates from all of my invoices > > > why do i need to filter by id=1 or by id<now() ? > > You don't, Patricio misunderstood your question. > > The answer is something like this (untested) > > from sqlalchemy.sql import * > DBSession.execute(select([Invoice.date], distinct=True)) > > It might be that distinct=True is wrong, but instead is a separate call, like > > select([...]).distinct(). > > Check the SQLAlchemy-docs on this. > > Diez -- You received this message because you are subscribed to the Google Groups "TurboGears" 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/turbogears?hl=en.
