On Wed, May 14, 2008 at 3:13 PM, Jonathan Wage <jonw...@gmail.com> wrote:
> Try capitalized WITH? Also I would use tokens in your query. ? instead of
> directly concatenating it in to the DQL query.

> - Jon

> On Wed, May 14, 2008 at 1:10 PM, Alex <outroa...@gmail.com> wrote:

>>  $query = Doctrine_Query::create()->from('CommentItem
>> c')->leftJoin('c.sfGuardUser u')->leftJoin('c.VoteComment vc with vc.user_id
>> = '.$this->getUser()->getId());
>>     }

>>     $treeObject = $commentTable->getTree();
>>     $treeObject->setBaseQuery($query);

>>     echo $treeObject->getBaseQuery()->getSqlQuery();

>> Output is

>> "SELECT c.id AS c__id, c.lft AS c__lft, c.rgt AS c__rgt, c.level AS
>> c__level, c.root_id AS c__root_id FROM comments c LEFT JOIN sf_guard_user s
>> ON c.user_id = s.id LEFT JOIN votes v ON c.id = v.comment_id WHERE
>> (v.type = 2 OR v.type IS NULL)"

>> Doctrine seems to be discarding my last leftJoin's with condition. Is this
>> a bug or am I doing something wrong?
>> --

>> - Alex

> --
> Jonathan Wage
> http://www.jwage.com
> http://www.centresource.com