RE: [PEAR] Dataobject : complex jointures
| From: | David Alia | Date: | Tue, 26 Jul 2005 22:08:31 +0000 |
| Subject: | RE: [PEAR] Dataobject : complex jointures | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-20155@lists.php.net to get a copy of this message | ||
-----Message d'origine-----
De : Justin Patrin [mailto:papercrane@gmail.com]
Envoyé : mardi 26 juillet 2005 20:40
À : David Alia
Cc : pear-general@lists.php.net
Objet : Re: [PEAR] Dataobject : complex jointures
On 7/26/05, David Alia <david.alia@gmail.com> wrote:
> >
> > I must be an idiot but I can't get to do it :
> >
> > when I write :
> >
> > $D->selectAdd('A1, A2, A3, E1');
> >
> > I get an error (unknown column E1)
>
> >>Does the E1 column exist? Is the join of E working? Try
> >>DB_DataObject::debugLevel(1) to see the SQL that is generated and
> >>any
> errors that may be happening.
>
> Yep, E1 exists. I've checked with debugLevel up to 5. The SQL select
> does not include "E" tables so it's not working...
>
>> Then your joinAdd to E is not working. Do you perhaps see an error when
you do $B->joinAdd($E) with debugging turned on? Are you sure you set up the
links right (no typos)?
No error during this joinAdd... Maybe this kind of link is impossible ?
David