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 (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/a.talk%40zenn.net
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/mschrag%40mdimension.com
This email sent to [EMAIL PROTECTED]
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
