setDefaultSort problem with two identical column names, MDB2

[jannie00]

Hello,

I use the MDB2 datasource in combination with DataGrid and have the following problem:

If have a query with two identical column names like:

SELECT
a.name AS aname,
b.name AS bname
FROM
a,
b
WHERE
a.id = b.id

When I do in my PHP code:

...
$DataGrid->setDefaultSort(array(
'name' => 'DESC'
));
$DataGrid->bind($query, $options);
...

I get the MDB2 error:

Column 'name' in order clause is ambiguous

Even when I remove 'b.name AS bname' from the query I get the error message. Also tried to use the alias ('aname') as default sort, same error. Has anyone a solution? Is it a bug? Do I have to change one of the column names in the database (rather not, it is used a lot)?

Regards, Chris

[mark]

[jannie00]

You are right. It does work now when using the alias. Something else in the query was causing the error.

Sometimes you just need a good nights sleep...

Regards, Chris