Help me write subquery in update query - doctrine-user

Message from discussion Help me write subquery in update query

mich

More options 6 July, 08:23

From: mich <michaile...@gmail.com>

Date: Mon, 6 Jul 2009 00:23:23 -0700 (PDT)

Local: Mon 6 July 2009 08:23

Subject: Re: Help me write subquery in update query

  Reply to author
  |
  Forward | Print | View thread
  | Show original
  | Report this message | Find messages by this author
  

Anyone? What am I doing wrong?

On 3 июл, 22:58, mich <michaile...@gmail.com> wrote:

> 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()
> ;

> but it throws exception "Unknown component alias Comment".

Reply to author Forward