Hi !

I was wondering why this code works :

$c->addSelectColumn('SUM('. ShopOrderPeer::PRICE. ')');           

Whereas this one doesn't

$c->addSelectColumn('ROUND(SUM('. ShopOrderPeer::PRICE. '),2)');           

It seems that the FROM clause of the query is always broked when using more 
that one mysql function in 
or may be i am missing something obvious ? 

>> FROM SUM(shops_orders, shops_orders, shops, orders WHERE 


Any idea ?




      
_____________________________________________________________________________ 
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail 
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to