For Programmers: Free Programming Magazines  


Home > Archive > PHP Pear > July 2005 > RE: [PEAR] Dataobject : complex jointures









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author RE: [PEAR] Dataobject : complex jointures
David Alia

2005-07-26, 5:02 pm

>
> 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)


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...
[color=darkred]
>
> when I write :
>
> $D->selectAs($E, 'E_%s');
>
> I get an error (D has no link with E)
>
> I've tried lots of possibilities but nothing comes...
>

[color=darkred]
;-) I tend to just use selectAdd.
[color=darkred]

I've tried this too. But, like the previous one, E table is not in the
query, I get an SQL error.
I've worked on a workaround (getting all infos from A, B, C and D first,
then looking for fields from E. Not great but...)

Thanks a lot for your help. If you think about a solution (during the night
maybe ? :)), feel free :-)

David

--
Justin Patrin
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com