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

[Chuck Hagenbuch]

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