[symfony-users] Propel query

2009-09-22 Thread korfos
Hello all, I want to create the following query using propel: SELECT acticles.title, count(comments.id) FROM articles LEFT JOIN comments ON comments.article_id = articles.id group by articles.title Is this posible? Regards, Radu. --~--~-~--~~~---~--~~ You recei

[symfony-users] Re: Override default error pages

2009-07-23 Thread korfos
You can create a new security module and in the actions.class.php create error404Execute function. After you've customized the error404Success.php template, uncomment and modify in apps\frontend \config\settings.yml the following: .actions: error_404_module: security # To be called

[symfony-users] Re: Multiple foreign keys for the same table

2009-03-01 Thread korfos
t;addAlias("T3_2", UsersPeer::TABLE_NAME); > > > // Create Joins > > $c->addJoin(ArticlePeer::CREATEDBY_ID, UsersPeer::alias("U1", > > UsersPeer::ID)); > > $c->addJoin(ArticlePeer::CREATEDBY_ID, UsersPeer::alias("U1", > > > > >

[symfony-users] Multiple foreign keys for the same table

2009-02-27 Thread korfos
Hello all, I'm new to symfony, so be gentle :) I have to tables: users {id, name} article{id, createdby_id, modifiedby_id} createdby_id and modifiedby_id are foreign keys to users table When i do: $c = new Criteria(); $c->addJoin(ArticlePeer::CREATEDBY_ID, UsersPeer::ID); $c->addJoin(ArticlePee