Re: How to build EOQualifier which generates "IN" SQL statement
Re: How to build EOQualifier which generates "IN" SQL statement
- Subject: Re: How to build EOQualifier which generates "IN" SQL statement
- From: Colin Clark <email@hidden>
- Date: Wed, 24 Aug 2005 11:02:52 -0400
Hi Gennady,
It's not possible to use "IN" with a standard WO EOQualifier as far
as I know. Pierre Bernard, however, has written his own subclass
which will support this. Have a look at:
http://homepage.mac.com/i_love_my/code.html
I hope that helps,
Colin
On 24-Aug-05, at 10:38 AM, Kushnir Gennady wrote:
Hello all
How to perform SQL with "IN" selector to get Enterprise Objects as
a result?
I have EO with "type" attribute (which is link to another EO).
I want to fetch from database EOs of several "type"s. Of course I
can use something like
"type = good OR type = bad OR type = fine" etc.
However this does not seem efficient. SQL database provides single
statement for this
"type IN (good, bad, fine, etc.)"
So I tried to find EOQualifier which would take an array of values
to put them into IN statement
and I found nothing :(.
Can anyone gime sime advice on this?
Thanks in advance
Gennady
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40mac.com
This email sent to email@hidden
_______________________________________________
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