Re: DB_DataObject::joinAdd issue

Alan Knowles wrote:

had a quick look at this, you are probably best adding $run->selectAdd('tTrain.id as tTrain_id, tSchedRun.id as tSchedRun_id');

I don't think this will work, as the find() is applied to the train object. I don't recall the selectAdd of the object to be joined is added to to the object joined upon. You might try $train->selectAdd('tTrain.id as tTrain_id, tSchedRun.id as tSchedRun_id'); This should work, but I don't know if this is a nice implementation. Maybe joinAdd() should import the select conditions set in the joined object. Alan, a word from you about this? I can work on it the next couple of days if you like. I'm using the same sort of thing for my own code, but I don't recall having problems with the 2 'id' columns, I'll look into it... Also, I noticed that addJoin() is still using the addslashes() function, instead of the $__DB->quote() method, I'll apply a patch shortly. Stijn

I'm reluctant to add to much magic behind the scenes here, as doing join is confusing enough without adding to much unexpected behavour.. Regards Alan