How to build EOQualifier which generates "IN" SQL statement
How to build EOQualifier which generates "IN" SQL statement
- Subject: How to build EOQualifier which generates "IN" SQL statement
- From: Kushnir Gennady <email@hidden>
- Date: Wed, 24 Aug 2005 18:38:45 +0400
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:
This email sent to email@hidden