• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: creating my EOQualifier in code
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
References: 
 >Re: Re: creating my EOQualifier in code (From: Alex Cone <email@hidden>)

  • Prev by Date: Re: Writing Oracle Blobs under WO 5.4 - WO fails
  • Next by Date: Re: Writing Oracle Blobs under WO 5.4 - WO fails
  • Previous by thread: Re: Re: creating my EOQualifier in code
  • Next by thread: TPTP on Mac?
  • Index(es):
    • Date
    • Thread