[dev] Re: [cvs] commit: framework/DataTree/DataTree sql.php

[Ben Chavet]

Awesome, works great!  Thanks guys!

--Ben

Quoting Chuck Hagenbuch <chuck at horde.org>:

> Quoting Duck <duck at obala.net>:
>
>> return sprintf('SELECT %s FROM %s c %s WHERE c.group_uid = %s AND %s %s %s
>> GROUP BY a1.datatree_id, c.datatree_name  ORDER BY c.datatree_order,
>> c.datatree_name, c.datatree_id',
>>
>> note the ", c.datatree_name" added in the group by column
>
> Needed datatree_order too, and to group on c.datatree_id, not a1.datatree_id.
> Tested with both postgres and mysql now and committed; should be working.
>
> -chuck
>
> --
> "Regard my poor demoralized mule!" - Juan Valdez
>
> --
> Horde developers mailing list - Join the hunt: http://horde.org/bounties/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: dev-unsubscribe at lists.horde.org
>
>