How to do a join with ttwo tables ??

Posted by bahamut100 on Stack Overflow See other posts from Stack Overflow or by bahamut100
Published on 2010-06-03T07:06:15Z Indexed on 2010/06/03 7:14 UTC
Read the original article Hit count: 225

Filed under:

symfony

|

criteria

|

propel

HI,

I try to translate this query :

SELECT *
FROM `reunion` , lieu
WHERE reunion.lieu_reunion = lieu.id_lieu

to propel query :

$c=new Criteria();
$c->addJoin(ReunionPeer::LIEU_REUNION,LieuPeer::ID_LIEU, Criteria::LEFT_JOIN);
$this->reunions = ReunionPeer::doSelect($c);

But in my template, when I made a print_r($reunions), the field "ville" (from the table 'lieu') is not present.

Why ??

© Stack Overflow or respective owner

Related posts about symfony

Symfony/Doctrine/SfGuardPlugin: Redirect to requested page (route), and not referrer

as seen on Stack Overflow - Search for 'Stack Overflow'
I want to be able to take the user to the requested page after login, but this does not happen with sfGuard. ** My Register action requires SignIn ;) ** On the listing page [http://cim/frontend_dev.php/] - user clicks the 'Register' link [@register = register/index] - user is taken to 'Signin' page… >>> More
Symfony and doctrine searchable sfDoctrinePager (symfony 1.4)

as seen on Stack Overflow - Search for 'Stack Overflow'
Can someone help me on paginating results with sfDoctrinePager? $articlesResults = Doctrine::getTable('Article') ->getTemplate('Doctrine_Template_I18n') ->getPlugin() … >>> More
Seems doctrine listener is not fired

as seen on Stack Overflow - Search for 'Stack Overflow'
Got a service which should be executed the moment an object is persisted. Though, I think the code looks like it should work, it doesn't. I configured the service like the following yml. services: bla_orm.listener: class: Bla\OrmBundle\EventListener\UserManager arguments:… >>> More
Ubuntu 13.10 Symfony installation date time issue

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm installing Symfony on my Ubuntu system, everything was going fine until the very last moment when I was met with a screen that said: ContextErrorException: Warning: date_default_timezone_get(): It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone… >>> More
Propel-load-data is causing an error

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to load fixtures but myproject is erroring at the CLI and starting the indexer process. I have tried: Rebuilding the schema and model Emptying the database and starting again Clearing the cache Validating the YML file and trying much simpler data-dumps My platform is Symfony 1.0… >>> More

Related posts about criteria

Hibernate Criteria: Add restrictions to Criteria and DetachedCriteria

as seen on Stack Overflow - Search for 'Stack Overflow'
Currently our queries add a variety of Restrictions to ensure the results are considered active or live. These Restrictions are used in several places/queries so a method was setup similar to public Criteria addStandardCriteria(Criteria criteria, ...) { // Add restrictions, create aliases… >>> More
Criteria SpatialRestrictions.IsWithinDistance NHibernate.Spatial

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone implemented this, or know if it would be difficult to implement this/have any pointers? public static SpatialRelationCriterion IsWithinDistance(string propertyName, object anotherGeometry, double distance) { // TODO: Implement throw new NotImplementedException(); } from NHibernate… >>> More
Hibernate Criteria query on association

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, How would I go about executing the following Hibernate query using the criteria API. I have an object Parent with List children. I would like to search through all parents and find which parents contain a specified child. i.e. List findParent(Child child); Thanks. >>> More
Delete all rows that do not have the value: Criteria 1 or Criteria 2 or Criteria 3 in Column D --> Using VBA Macro for excel

as seen on Stack Overflow - Search for 'Stack Overflow'
I am new to Macro's/VBA and cannot seem to figure out how to do this action for multiple criteria. I am trying to Delete all rows that do not have the value: Identify Fail or Identify Success in Column D. I write the following code and it works for one criteria "Identify Fail": '***********************************************' Sub… >>> More
More than one location provider at same time

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some problems with location systems. I have a service that implements locationlistener. I want to get the best location using network when possible, gps if network is not enough accurate (accuracy greater than 300mt). The problem is this. I need location (accurate if possible, inaccuarte otherways)… >>> More