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: Chuck Hill <email@hidden>
- Date: Wed, 24 Aug 2005 11:08:15 -0700
I'm trying to stay out of the Great Wonder Debate, but it is worth
noting that the license _does_ allow you to pretty much do what you
want with the code. This includes extracting bits to use in other
places. If you don't / won't / can't use all of Wonder, you can
still gain great benefit from parts of it. Again, yes, with some
reading and effort. Nothing comes for free.
Chuck
On Aug 24, 2005, at 8:06 AM, Guido Neitzer wrote:
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
--
Practical WebObjects - a book for intermediate WebObjects developers
who want to increase their overall knowledge of WebObjects, or those
who are trying to solve specific application development problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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