Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.11.5

Request #10858 joinAdd function
Submitted: 2007-04-27 10:32 UTC
From: banquette Assigned:
Status: Open Package: DB_DataObject
PHP Version: 5.2.1 OS:
Roadmaps: (Not assigned)    
Subscription  


 [2007-04-27 10:32 UTC] banquette (Alex Desktop)
Description: ------------ I d like to use the joinAdd method with a hard coded query like joinAdd("LEFt JOIN ..."); I did not find a way to pass throught a table ; i mean when a table is not directly "connected" to another. Test script: --------------- <-> means a relationship between table (FK/PK) table0 <-> table1 <-> table2 <-> table3 One can query table1 with a joinAdd on table0 and/or table2 but not with a joinAdd on table3 as there is no direct relationship. To do such a thing query must actually be hard coded... or I did not find the solution ... That s why I want a "joinAdd(string $join)" : to keep advantage of methods like selectAdd() to avoid a hard coded query. Thanks.

Comments

 [2007-04-27 12:13 UTC] banquette (Alex Desktop)
I forgot to say I use an array as argument of joinAdd for instance : $obj->joinAdd(array('fk_id','table'.':'.'id'),'left');