Re: creating my EOQualifier in code
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