Re: DB_DataObject joining, sorting and ambiguous field name
| From: | Alan Knowles | Date: | Wed, 02 Nov 2005 02:50:13 +0000 |
| Subject: | Re: DB_DataObject joining, sorting and ambiguous field name | ||
| References: | 1 2 3 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-40376@lists.php.net to get a copy of this message | ||
The * is the for backward compatibility, removing/replacing it would
probably break to many things.
Regards
Alan
On Tue, 2005-11-01 at 22:49 +0100, Olivier Guilyardi wrote:
> 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
>