Hi, 

I have notice somthing with the addJoin method :

if I set the parameters like that :

criteria.addJoin(PersonPeer.person_sid, ActivityPeer.person_sid);
criteria.addJoin(CompanyPeer.company_sid, ActivityPeer.company_sid);

the query string don't put Activity table after the FROM

SELECT [...] FROM person, company WHERE [...]

but if I set the parameters like that : 

criteria.addJoin(ActivityPeer.person_sid, PersonPeer.person_sid);
criteria.addJoin(ActivityPeer.company_sid, CompanyPeer.company_sid);

It's OK. In the query string, the activity table is in the FROM clause :

SELECT [...] FROM person, company, activity WHERE [...]

Why doesn't it work in the first case (bug or misundersanding of my part) ?

regards

















------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Search: <http://www.mail-archive.com/turbine%40list.working-dogs.com/>
Problems?:           [EMAIL PROTECTED]

Reply via email to