Yeah I'm trying to do the same thing. If you find a solution please post it thanks.
On Oct 7, 1:40 pm, fael <[email protected]> wrote: > Hello > I'm coding this reddit-like clone and so far, so good, just I want to > show how many ups and how many downs are by post in the index. > Something like this: > Up (20) | Down (3) This is the first title > Up (10) | Down (10) Second title here > Up (5) | Down (6) Third title! > > A findAll will get me the Post data and then I'll just have to make a > hasOne relationshi with aCOUNT, right? It would be something like > this: > $this->bindModel(array( > "hasMany" => array( > "VoteNeg" => array( > "className" => "Votes", > "fields" => array("COUNT(VoteNeg.id)"), > "conditions" => array("VotoNeg.value" => 0) > ), > "VotePos" => array( > "className" => "Votes", > "fields" => array("COUNT(VotePos.id)"), > "conditions" => array("VotePos.value" => 1) > ) > ) > )); > > The thing is, this COUNTs the totalvotesfor all the three records. > SELECTCOUNT(`VotoNeg`.`id`), `VotoNeg`.`propuesta_id` FROM `votos` AS > `VotoNeg` WHERE `VotoNeg`.`valor` = 0 AND `VotoNeg`.`propuesta_id` IN > (2, 3, 1) > > I'm using hasMany as hasOne oddly just returns one record, and > includes every vote, regardless of which post it belongs to. > > I think I have to use DISTINCT, but I've tried and still won't work > the way it should. > Am I missing something? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
