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  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 24 + 22 = ?

 
 [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');