I could solve it:
$q = Doctrine_Query::create()
->select('DISTINCT(k.bezeichnung) AS
bezeichnung')
->from('Kompetenzen k');
Pretty easy ;)
On Nov 6, 10:52 am, mahadi <[email protected]> wrote:
> Hi,
>
> im trying to select some entries out of the databse wtih the following
> query:
>
> $q = Doctrine_Query::create()
> ->select('k.bezeichnung')
> ->distinct()
> ->from('Kompetenzen k');
>
> Generatet Query: SELECT DISTINCT k.kompetenz_id AS k__kompetenz_id,
> k.bezeichnung AS k__bezeichnung FROM kompetenzen k
>
> The problem with it: Distinct wont work as expected because the id of
> the entries is selected too automatically.
>
> How can i turn of this behaviour?
--
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
