Yay I figured it out on my own $c->addHaving($c->getNewCriterion(MlVideoPeer::ID, 'votecount<=10', Criteria::CUSTOM));
On Feb 28, 1:06 pm, Joshua <[email protected]> wrote: > Sorry above example should be > > while($video = $videos->fetch(PDO::FETCH_ASSOC)) > > On Feb 28, 1:05 pm, Joshua <[email protected]> wrote: > > > Propel 1.3 symfony 1.2.2 > > > I have gotten this far with custom columns > > > $c= new Criteria(); > > $c->addAsColumn('votecount', 'COUNT > > ('.MlVideoVotesPeer::ML_VIDEO_ID.')'); > > $videos = MlVideoPeer::doSelectStmt($c); > > > while($route = $featuredRoutes->fetch(PDO::FETCH_ASSOC)) > > { } > > > This allows me to access votecount. But I can't find a way to add > > votecount to WHERE. I have tried different versions of this > > > $c->add('votecount', 'votecount<='. 10, Criteria::CUSTOM); > > > Which return errors like > > > [wrapped: SQLSTATE[42S22]: Column not found: 1054 Unknown column > > 'votecount' in 'where clause'] --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
