> Hello there,

> i encountered a problem, when using a left join command in a query.
> Basically, what happened is that my joined results were not appearing
> in the final results of the query. After carefully testing the
> validity of the actual query (by testing the query to mysql directly)
> i realized that the problem can not originate from mysql as such.

> A few details:

> Model A:
> Consists of an (primary key) 'id' of type string, length 16
> and a few other fields, most importantly for this example a field
> 'code' (string/10)

> Model B:
> Has a field 'mandantPath' that is related to model A (field id)
> through a hasOne() relation.

> #code
> $this->hasOne('mandant_db_node as mandant', array
> ('local'=>'mandantPath','foreign'=>'id'));

> #here is my query

>        $l=Doctrine_Query::create()
>                         ->select('*,p.code')
>                         ->from('contact_db_customer cc')
>                         ->leftJoin('cc.mandant p')
>                         ->where($w)
>                         ->offset($request['startindex']+0)
>                         ->limit($request['rows']+0)
>                         ->orderBy($order)
>                         ->execute(array());

> Now, if i call this the way i do (above), i get the basic results
> (fields), but not the joined ones. If i get the SQL query generated by
> Doctrine, and use it directly, it works just fine and it returns the
> 'code' field as it should.

> However, when i add type Doctrine::HYDRATE_ARRAY to the execute
> command, i get the correct results, but of course encapsuled.. so that
> i have to loop/parse through the result and set the values according
> to my demands.

> Pretty frustrating - while i am certain that the problem is very basic
> and i just lack the knowledge of a proper solution. Hopefully someone
> in here knows what i am dealing with - specifically, what it is that i
> am doing wrong.

> Kind regards, James