> Thanks in advance.

> Robert

> Additional Information:
> I forgot the where condition:
> SELECT *, (product_price * count_product) as sum_price FROM
> shoppingcart WHERE sum_price > 50

> Best regards
> Robert

> On 2 Jul., 19:15, robert henniger <robert.henni...@googlemail.com>
> wrote:
> > Hi to all.
> > Is it possible to use mathematical operations and "extend" the
> > selected resultset with additional/virtual "fields?
> > Example:
> > SELECT *, (product_price * count_product) as sum_price FROM
> > shoppingcart

> > Thanks in advance.

> > Robert

> - Jon

> On Wed, Jul 2, 2008 at 12:19 PM, robert henniger <

> robert.henni...@googlemail.com> wrote:

> > Additional Information:
> > I forgot the where condition:
> > SELECT *, (product_price * count_product) as sum_price FROM
> > shoppingcart WHERE sum_price > 50

> > Best regards
> > Robert

> > On 2 Jul., 19:15, robert henniger <robert.henni...@googlemail.com>
> > wrote:
> > > Hi to all.
> > > Is it possible to use mathematical operations and "extend" the
> > > selected resultset with additional/virtual "fields?
> > > Example:
> > > SELECT *, (product_price * count_product) as sum_price FROM
> > > shoppingcart

> > > Thanks in advance.

> > > Robert

> --
> Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com

> Hi Jon,
> sorry but i dont understand.
> Can you give me more information?

> Robert

> On 2 Jul., 20:32, "Jonathan Wage" <jonw...@gmail.com> wrote:
> > Yes.

> > - Jon

> > On Wed, Jul 2, 2008 at 12:19 PM, robert henniger <

> > robert.henni...@googlemail.com> wrote:

> > > Additional Information:
> > > I forgot the where condition:
> > > SELECT *, (product_price * count_product) as sum_price FROM
> > > shoppingcart WHERE sum_price > 50

> > > Best regards
> > > Robert

> > > On 2 Jul., 19:15, robert henniger <robert.henni...@googlemail.com>
> > > wrote:
> > > > Hi to all.
> > > > Is it possible to use mathematical operations and "extend" the
> > > > selected resultset with additional/virtual "fields?
> > > > Example:
> > > > SELECT *, (product_price * count_product) as sum_price FROM
> > > > shoppingcart

> > > > Thanks in advance.

> > > > Robert

> > --
> > Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com

> $q = Doctrine_Query::create()
>           ->select('u.*, (u.num_posts / 24) as num_posts_per_day')
>           ->from('User u')
>           ->orderBy('num_posts_per_day asc');

> $topPosters = $q->fetchArray();

> Note: I didn't test the above code but I know that the concept works, so
> their may be a typo or mistake or something. Give it a try.

> - Jon

> On Wed, Jul 2, 2008 at 7:39 PM, robert henniger <

> robert.henni...@googlemail.com> wrote:

> > Hi Jon,
> > sorry but i dont understand.
> > Can you give me more information?

> > Robert

> > On 2 Jul., 20:32, "Jonathan Wage" <jonw...@gmail.com> wrote:
> > > Yes.

> > > - Jon

> > > On Wed, Jul 2, 2008 at 12:19 PM, robert henniger <

> > > robert.henni...@googlemail.com> wrote:

> > > > Additional Information:
> > > > I forgot the where condition:
> > > > SELECT *, (product_price * count_product) as sum_price FROM
> > > > shoppingcart WHERE sum_price > 50

> > > > Best regards
> > > > Robert

> > > > On 2 Jul., 19:15, robert henniger <robert.henni...@googlemail.com>
> > > > wrote:
> > > > > Hi to all.
> > > > > Is it possible to use mathematical operations and "extend" the
> > > > > selected resultset with additional/virtual "fields?
> > > > > Example:
> > > > > SELECT *, (product_price * count_product) as sum_price FROM
> > > > > shoppingcart

> > > > > Thanks in advance.

> > > > > Robert

> > > --
> > > Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com

> --
> Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com

> Thank you Jon,
> it works now. I tested it yesterday but i think i did something wrong
> then.
> Sorry for that!
> Can i use every "mysql" function for the expression or which functions
> are supported?
> I am asking because in mysql you use "rand()" and this will not work.
> When i use "random()" it works.

> Is there something i have to keep in mind?

> Best regards

> PS: By the way, doctrine rocks and is a perfect tool for me.
> The learning phase is a bit long but it is very cool and i am looking
> forward for the release.

> On 3 Jul., 05:28, "Jonathan Wage" <jonw...@gmail.com> wrote:
> > DQL has the same ability to specify expressions like SQL can.

> > $q = Doctrine_Query::create()
> >           ->select('u.*, (u.num_posts / 24) as num_posts_per_day')
> >           ->from('User u')
> >           ->orderBy('num_posts_per_day asc');

> > $topPosters = $q->fetchArray();

> > Note: I didn't test the above code but I know that the concept works, so
> > their may be a typo or mistake or something. Give it a try.

> > - Jon

> > On Wed, Jul 2, 2008 at 7:39 PM, robert henniger <

> > robert.henni...@googlemail.com> wrote:

> > > Hi Jon,
> > > sorry but i dont understand.
> > > Can you give me more information?

> > > Robert

> > > On 2 Jul., 20:32, "Jonathan Wage" <jonw...@gmail.com> wrote:
> > > > Yes.

> > > > - Jon

> > > > On Wed, Jul 2, 2008 at 12:19 PM, robert henniger <

> > > > robert.henni...@googlemail.com> wrote:

> > > > > Additional Information:
> > > > > I forgot the where condition:
> > > > > SELECT *, (product_price * count_product) as sum_price FROM
> > > > > shoppingcart WHERE sum_price > 50

> > > > > Best regards
> > > > > Robert

> > > > > On 2 Jul., 19:15, robert henniger <robert.henni...@googlemail.com>
> > > > > wrote:
> > > > > > Hi to all.
> > > > > > Is it possible to use mathematical operations and "extend" the
> > > > > > selected resultset with additional/virtual "fields?
> > > > > > Example:
> > > > > > SELECT *, (product_price * count_product) as sum_price FROM
> > > > > > shoppingcart

> > > > > > Thanks in advance.

> > > > > > Robert

> > > > --
> > > > Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com

> > --
> > Jonathan Wagehttp://www.jwage.comhttp://www.centresource.com