On 6/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:

how would i do a select with sqlobject that would emulate this sql...

select vendor, sum(balance) from invoice group by vendor order by
sum(balance) desc;

disclaimer this is not a RTFM reply.

you need the sqlbuilder feature, it is very undocumented for complex cases but this links should give you an undestanding

do a search on google for sqlobject sqlbuilder

the first link is an intro do the tool the second,3th,etc are links to the api docs.


--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to