On Wed, May 14, 2008 at 3:18 PM, Jonathan Wage <jonw...@gmail.com> wrote:
> It is good practice. You should always use them so that all values are
> prepared. In this case it doesn't matter as much since the value isn't
> necessarily user input.

> - Jon

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

>>  Bingo! That worked. All DQL commands must be uppercased? What's the
>> advantage of using the tokens?

>> 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

>> --

>> - Alex

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