Re: Dataobject : complex jointures
| From: | Justin Patrin | Date: | Wed, 27 Jul 2005 04:58:45 +0000 |
| Subject: | Re: Dataobject : complex jointures | ||
| References: | 1 2 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-20158@lists.php.net to get a copy of this message | ||
On 7/26/05, David Alia <david.alia@gmail.com> wrote:
>
>
> -----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 ?
>
Nope, you can link any way that normal SQL can.
--
Justin Patrin