Hi, I've a problem with this working out:
$c->addAsColumn('tagg', '(SELECT COUNT(*) FROM wzory_tagi, tagi WHERE wzory_tagi.WZOR_ID=wzory.ID AND wzory_tagi.TAG_ID=tagi.ID AND tagi.tag LIKE "")'); $c->add($c->getColumnForAs('tagg'), 0, Criteria::ALT_NOT_EQUAL); $c->addDescendingOrderByColumn($c->getColumnForAs('tagg')); the thing is that without add criteria it's working fine but i want to add criteria when column tagg is 0 then don't display this record i get this error: [PropelException] [wrapped: Cannot fetch TableMap for undefined table: (SELECT COUNT(*) FROM wzory_tagi, tagi WHERE wzory_tagi] Thanks for any help, Karol. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---