hi.
->select('MAX(v.rang) AS max_rang, v.*') should do the job.
Alias "is not set" because there's nothing to "attach" alias to. Because
only *one* column is fetched by SELECT — an *aggregate column itself*.
2010/4/17 NOOVEO - Christophe Brun <c.b...@nooveo.fr>
> After the Doctrine documentation,
> http://www.doctrine-project.org/documentation/manual/1_2/en/dql-doctrine-query-language:select-queries:aggregate-values
> I'm trying a query like this :
>
> $vp = Doctrine_Query::create()
> ->select('MAX(v.rang) AS max_rang')
> ->from('VitrineParagraphe v')
> ->where('v.vitrine_id = ?', $vitrineId)
> ->execute();
>
> The executed query, is after the logs :
> SELECT MAX(v.rang) AS v__0 FROM vitrine_paragraphe v WHERE (v.vitrine_id =
> ?) - (17)
>
> and of course, the further $vp->max_rang used to retrieve the desired value
> fails.
> Any ideas why the alias is not set ?
>
>
> --
> If you want to report a vulnerability issue on symfony, please send it to
> security at symfony-project.com
>
> You received this message because you are subscribed to the Google
> Groups "symfony users" group.
> To post to this group, send email to symfony-users@googlegroups.com
> To unsubscribe from this group, send email to
> symfony-users+unsubscr...@googlegroups.com<symfony-users%2bunsubscr...@googlegroups.com>
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en
>
--
With the best regards, Andrei.
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
