Actually it was only example to demonstrate my problem, I'm using sfPropelPager to display my articles, do my code looks like this in real
$pager = new sfPropelPager('Article', 5); $pager->setCriteria($c); $pager->setPage($this->getRequestParameter('page', 1)); $pager->init(); How can I use this feature in this way? I was wandering if there's some Criteria feature to do this On Oct 10, 10:23 am, tsyr2ko <[EMAIL PROTECTED]> wrote: > Try this, > > $articlesList = ArticlePeer::doSelectJoinCategory(new Criteria()); > > On 10 oct, 11:34, javo <[EMAIL PROTECTED]> wrote: > > > Hi all > > > I have on little problem and I'm new to symfony and I can't find aby > > sulution, > > > My article model looks like this -> > > article: > > id: { type: integer, required: true } > > title: { type: varchar, size: '255' } > > created_at: { type: timestamp } > > language_id: { type: integer } > > category_id: { type: integer } > > > my category model consist from id, and name only > > > If I try to use > > > $articlesList = ArticlePeer::doSelect(new Criteria()); > > I'll get all articles with their category ids, but I want to get also > > their names in one query .... > > is it possible? > > > thank you so much --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---