• 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: Chuck Hill <email@hidden>
  • Date: Mon, 25 Feb 2008 10:11:30 -0800

OK, let me amend my reply. Still waiting for the coffee to brew. :-) Unless the plugin does this, EOF generates Upper(column) = Upper(value).

Chuck


On Feb 24, 2008, at 10:02 AM, Mike Schrag wrote:

From the plugin:
public String sqlStringForCaseInsensitiveLike(String value, String column) {
StringBuffer sql = new StringBuffer();


			sql.append(column);
			sql.append(" LIKE ");
			sql.append(value);
			sql.append(" COLLATE INFORMATION_SCHEMA.CASE_INSENSITIVE");

			return sql.toString();
		}

On Feb 24, 2008, at 11:16 AM, Asa Hardcastle wrote:

Sounds like it is not a problem anymore. Once we find a workaround (as long as it isn't a huge hack), we seldom check to see whether things have changed. There have been several versions of FB and of the plugin since.

I haven't tried caseInsensitiveLike for years. I assume that it requires a CASE_INSENSITIVE collation on the field in the database, right? Otherwise, it would be extremely slow on medium/ large data sets.

asa




On Feb 24, 2008, at 10:19 AM, Mike Schrag wrote:


...rather; in webobjects qualifiers using caseInsentiveLike stopped working for us. Our database of choice is Frontbase.
Not sure what this is -- I use caseInsensitiveLike all the time with FrontBase and WO.

ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
40zenn.net


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:
40mdimension.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:
40global-village.net


This email sent to email@hidden

--

Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific 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


  • Follow-Ups:
    • Re: creating my EOQualifier in code
      • From: Mike Schrag <email@hidden>
References: 
 >Re: creating my EOQualifier in code (From: Theodore Petrosky <email@hidden>)
 >Re: creating my EOQualifier in code (From: Asa Hardcastle <email@hidden>)
 >Re: creating my EOQualifier in code (From: Asa Hardcastle <email@hidden>)
 >Re: creating my EOQualifier in code (From: Mike Schrag <email@hidden>)
 >Re: creating my EOQualifier in code (From: Asa Hardcastle <email@hidden>)
 >Re: creating my EOQualifier in code (From: Mike Schrag <email@hidden>)

  • Prev by Date: Re: creating my EOQualifier in code
  • Next by Date: Re: creating my EOQualifier in code
  • Previous by thread: Re: creating my EOQualifier in code
  • Next by thread: Re: creating my EOQualifier in code
  • Index(es):
    • Date
    • Thread