On 24 Jun 2006, at 18:02, Lee McFadden wrote:
> Just a note: Using Obj.select().count() actually only returns an
> integer and the SQL behind it reflects that. Using the .count()
> function doesn't retrieve all the objects, just the number of rows the
> selectresults object Obj.select() would retrieve.
True. I misunderstood the original question. In my case I need to
use sqlbuilder since I wanted not the count of elements but the sum of
the integer values of the element. ie
class Fred(SQLObject):
fred IntColumn(fred)
and I wanted the sum of fred for a given set of constraints.
I misunderstood the original question; since for the OP each
record is one visit there's no need to use sqlbuilder here.
Arthur
--
One secret of happiness is to ignore comparisons with people who are
more successful than you are: always compare downwards, not upwards”
- Richard Layard
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
