Message from discussion Help me write subquery in update query

MIME-Version: 1.0
Received: by 10.150.192.3 with SMTP id p3mr473711ybf.24.1246651110941; Fri, 03 
	Jul 2009 12:58:30 -0700 (PDT)
Date: Fri, 3 Jul 2009 12:58:30 -0700 (PDT)
X-IP: 77.89.246.143
User-Agent: G2/1.0
X-HTTP-UserAgent: Opera/9.64 (Windows NT 6.1; U; en) Presto/2.1.1,gzip(gfe),gzip(gfe)
Message-ID: <bbf36b0f-479b-40ff-a0d7-6a49d82d7673@b9g2000yqm.googlegroups.com>
Subject: Help me write subquery in update query
From: mich <michaile...@gmail.com>
To: doctrine-user <doctrine-user@googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I want to execute such sql:

update blog_entry set comment_number = (select count(*) from
blog_comment where blog_comment.root = blog_entry.id)

How I can write such query in DQL? I tried:

        $q = Doctrine_Query::create()
            ->update('Blog_Entry Entry')
            ->set('Entry.comment_number', '(SELECT COUNT(Comment.id)
FROM Entry.Blog_Comment Comment WHERE Comment.root = Entry.id)')
            ->execute()
        ;