Re: EOQualifier issue
Re: EOQualifier issue
- Subject: Re: EOQualifier issue
- From: Alexander Spohr <email@hidden>
- Date: Wed, 22 Nov 2006 10:49:24 +0100
Am 22.11.2006 um 09:39 schrieb Fabrice Pipart:
Is it me that asked for that in the Qualifier or that's a mistake
of EOF ?
It's EOF’s mistake.
EOF makes sure that you get your persons. So it needs to join them
with the employee and the employer tables. Therefore the AND. It has
no notion that you wanted to different joins - and those connected by
OR.
You are right. This is what you want:
(T1.COMPANY_FID = ? AND T0.ID = T1.PERSON_FID) OR (T2.COMPANY_FID = ?
AND T0.ID = T2.PERSON_FID)
But EOF can not create that for you, as it tries to qualify one
result set, that fits the given qualifier. You want two result-sets
in one select statement.
Solution: Do two fetches.
And use EOKeyValueQualifier and EOOrQualifier, thats cleaner and faster.
good luck,
atze
Freeport & Soliversum
Alexander Spohr
email@hidden
www.freeport.de
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden