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: Guido Neitzer <email@hidden>
- Date: Wed, 24 Aug 2005 17:06:37 +0200
On 24.08.2005, at 16:38 Uhr, Kushnir Gennady wrote:
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?
Perhaps you take a look at the In-Qualifier in ProjectWonder on how
to build your own qualifier for that (if you don't want to use Wonder).
<http://wonder.sourceforge.net/javadoc/er/extensions/
ERXInQualifier.html>
Perhaps you can just extract this qualifier from Wonder to your project.
cug
_______________________________________________
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