Message from discussion
Help me write subquery in update query
MIME-Version: 1.0
Received: by 10.150.140.6 with SMTP id n6mr1264304ybd.7.1246865003197; Mon, 06
Jul 2009 00:23:23 -0700 (PDT)
Date: Mon, 6 Jul 2009 00:23:23 -0700 (PDT)
In-Reply-To: <bbf36b0f-479b-40ff-a0d7-6a49d82d7673@b9g2000yqm.googlegroups.com>
X-IP: 77.89.246.143
References: <bbf36b0f-479b-40ff-a0d7-6a49d82d7673@b9g2000yqm.googlegroups.com>
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: <78f93abf-bd81-4c8d-92d6-20cd4bd4cf18@d4g2000yqa.googlegroups.com>
Subject: Re: Help me write subquery in update query
From: mich <michaile...@gmail.com>
To: doctrine-user <doctrine-user@googlegroups.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Anyone? What am I doing wrong?
On 3 =D0=B8=D1=8E=D0=BB, 22:58, mich <michaile...@gmail.com> wrote:
> I want to execute such sql:
>
> update blog_entry set comment_number =3D (select count(*) from
> blog_comment where blog_comment.root =3D blog_entry.id)
>
> How I can write such query in DQL? I tried:
>
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 $q =3D Doctrine_Query::create()
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ->update('Blog_Entry Entry')
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ->set('Entry.comment_number', '=
(SELECT COUNT(Comment.id)
> FROM Entry.Blog_Comment Comment WHERE Comment.root =3D Entry.id)')
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ->execute()
> =C2=A0 =C2=A0 =C2=A0 =C2=A0 ;
>
|
