Hello, I have a ProductCategory class with a method:
public function getActiveProductsQuery() { $q = Doctrine_Query::create() ->from('Product p, ProductCategory pc, ProductToProductCategory ptc') ->where('pc.slug = ?', $this->getId()) ->andWhere('pc.id = ptc.product_category_id') ->andWhere('p.id = ptc.product_id'); return Doctrine_Core::getTable('Product')->addActiveProductsQuery($q); } ProductTable.class has function: public function addActiveProductsQuery(Doctrine_Query $q = null) { if (is_null($q)) { $q = Doctrine_Query::create() ->from('Product p'); } return $q; } product_categoryActions has the SHOW of: public function executeShow(sfWebRequest $request) { $this->foo = $request->getParameterHolder(); $this->product_category = $this->getRoute()->getObject(); $this->pager = new sfDoctrinePager( 'Product', sfConfig::get('app_max_products_on_category') ); $this->pager->setQuery($this->product_category->getActiveProductsQuery()); $this->pager->setPage($request->getParameter('page', 1)); $this->pager->init(); } and showSuccess has: <?php echo count($pager) ?></strong> products in this category which shows a count of '0' Routing: product_category: url: product_category/:slug class: sfDoctrineRoute param: { module: product_category, action: show } options: { model: ProductCategory, type: object } Table structure is: product: id, name, description, etc... product_category: is, name, graphic, etc... product_to_product_category: product_id, product_category_id My issue is that I am not getting back any results and the count is '0' If I change $this->getId() to $this->getSlug() in: getActiveProductsQuery(), I get an error: '"ProductCategory" with an alias of "pc" in your query does not reference the parent component it is related to.' I have tried the sql out in phpMyAdmin and it works as expected, but not in symfony. Any suggestions as to what I am doing wrong would be great. Thanks. -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com 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 symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en