Re: creating my EOQualifier in code
Re: creating my EOQualifier in code
- Subject: Re: creating my EOQualifier in code
- From: Mike Schrag <email@hidden>
- Date: Mon, 25 Feb 2008 00:32:03 -0500
% is SQL syntax ... In EOQualifier syntax, you want to use *
ms
On Feb 25, 2008, at 12:28 AM, Theodore Petrosky wrote:
I am using the caseinsensitiveLike however I can not
get the global '%' to work...
EOQualifier newQual =
EOQualifier.qualifierWithQualifierFormat
("(client caseInsensitiveLike %@%%) AND (isComplete =
0)", arg1);
notice the %% (escaped percent). What could be wrong
with this??
Ted
<email@hidden>
Content-Type: text/plain; charset="us-ascii"
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:
@zenn.net
This email sent to email@hidden
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
http://lists.apple.com/pipermail/webobjects-dev/attachments/20080224/67516386/attachment.html
------------------------------
Message: 2
Date: Sun, 24 Feb 2008 13:02:25 -0500
From: Mike Schrag <email@hidden>
Subject: Re: creating my EOQualifier in code
To: WebObjects-Dev List
<email@hidden>
Message-ID:
<email@hidden>
Content-Type: text/plain; charset="us-ascii"
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();
}
____________________________________________________________________________________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
_______________________________________________
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
_______________________________________________
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