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() ? On Mar 15, 7:59 pm, Patricio Valarezo Lozano <[email protected]> wrote: > Rotem Tamir wrote: > > hi > > > i need to do: > > > select distinct(date) from invoice where 1 > > > been googling my eyes out for the past few hours.. > > > (using tg1.1 w/elixir) > > > any help? > > > rotem > > Invoice.query.filter(Invoice.date<=mydate).filter(Invoice.id==1).distinct().first() > > -- > patoVala > Linux User#280504 > Hablando enhttp://www.elprimoalcahuete.com > "No basta saber, se debe tambi n aplicar; no es suficiente querer, se > debe tambien hacer. -- Johann Wolfang Von Goethe. (1749-1832) Escritor > alem n. " -- 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.
