Hi Marco, Do you use as following:
$c = new Criteria(); $c->add(NewscatPeer::NAME, $name, Criteria::EQUAL); $pager = new sfPropelPager('News', 15); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->setPeerMethod('doSelectJoinNewscatPeer'); $pager->setPeerCountMethod('doCountJoinNewscatPeer'); $pager->init(); $this->pager = $pager; If it is, check your post value. On 6/23/07, Marco <[EMAIL PROTECTED]> wrote: > > Hi, i've noticed that when i try to filter data using a join, the > pager function getNbResults() returns an incorrect number of results. > For example in a set of 45171 if i try to filter records using a join > i get 119501 as total records that it's impossible (using the same > query in mysql i get 21,464 as total records filtered) > > How can i resolve this problem? Any idea? > Thanks > > > > > -- Birchandra Sanasam Web Developer & Analyst Major & Minor Exims. Pvt. Ltd. 704-B Tower, Millennium Plaza Sushant Lok - I, Gurgaon - 2 # +91 9810 194978 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to symfony-users@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---