Hi,
Did you try:
$article = sfPropelFinder::from('dbTimeBlock')->
withColumn('sum(dbTimeBlock.Total)', 'total')->
findOne();
$sum = article->getColumn('total');
François
2008/9/23 DigitalBase <[EMAIL PROTECTED]>:
>
> Hi, we are using propel addSelectColumn functionality to do a SUM on
> database level without object hydratation like this :
>
> $c = new Criteria();
> $c->addSelectColumn('sum('.dbTimeBlockPeer::TOTAL.') as total');
>
> $rs = dbTimeBlockPeer::doSelectRS($c);
> while ($rs->next()) { $total = $rs->getInt(1); }
>
> return $total;
>
> Now i am cleaning all my *Peer custom methods by dbFinder ones, but i
> haven't figured out howto do a sum() and returning a non-hydrated
> resultset.
>
> would be nice to have something like :
> $article = sfPropelFinder::from('dbTimeBlock')->
> getSum(dbTimeBlock.total)
>
>
> Is there anyway i could do this with dbFinder ?
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" 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/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
