Help me write subquery in update query - doctrine-user

Message from discussion Help me write subquery in update query

mich

More options 3 July, 20:58

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

Date: Fri, 3 Jul 2009 12:58:30 -0700 (PDT)

Local: Fri 3 July 2009 20:58

Subject: Help me write subquery in update query

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

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