Re: creating my EOQualifier in code
Re: creating my EOQualifier in code
- Subject: Re: creating my EOQualifier in code
- From: Alan Ward <email@hidden>
- Date: Mon, 25 Feb 2008 18:09:16 -0700
I don't know about OpenBase but with Oracle you can create an index
on upper(column)
and in fact you probably should do so if you're doing
caseInsensitiveLikes
Alan
On Feb 25, 2008, at 5:46 PM, Alex Cone wrote:
Fore OpenBase caseInsensitiveLike gets transmogrified to "like" as
that is already
case insensitive in OpenBase-land.
The problem to avoid is that often by comparing to "upper(column)"
you bypass
any indexes on that column.
The FrontBase and OpenBase plug-ins avoid this in their handling of
this query
component.
abc
On Feb 25, 2008, at 12:09 PM, webobjects-dev-
email@hidden wrote:
From: Mike Schrag <email@hidden>
OK, let me amend my reply. Still waiting for the coffee to
brew. :-) Unless the plugin does this, EOF generates Upper
(column) = Upper(value).
That excerpt I pasted was from FrontBasePlugIn ...
Yes, but there are other databases... :-)
Just clarifying -- I couldn't tell if you were responding to my post,
or to the thread in general.
ms
__alex cone
ceo c o d e f a b llc
email@hidden
212.465.8484 x101
http://www.codefab.com
If you are not living on the edge, you are taking up too much space.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40apple.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