Re: DB_DataObject joining, sorting and ambiguous field name
| From: | Olivier Guilyardi | Date: | Tue, 01 Nov 2005 21:49:37 +0000 |
| Subject: | Re: DB_DataObject joining, sorting and ambiguous field name | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-40373@lists.php.net to get a copy of this message | ||
Alan Knowles wrote:
> On Mon, 2005-10-31 at 19:54 +0100, Olivier Guilyardi wrote:
>>
>>Allessandro Pasotti has reported problems with sorting, when using
>>Structures_DataGrid over joined DataObjects.
>>
>>I have tried to do such configuration using the DB_DataObject::selectAs()
>>method, but it failed :
>>- both my tables have a 'name' field
>
> issue this, beforehand.
> $do1->selectAs();
> - it removes the *,l and replaces it with all the real table column
> names.
That works. Thanks. But why not using real column names by default instead of
"*" ? If it helps MySQL ensuring the column names are not ambiguous...
--
og