Yeah you are right ...
ms
On Feb 25, 2008, at 12:58 AM, Chuck Hill wrote:
And I think you need to add the *...* to the value in arg1, not the
format.
On Feb 24, 2008, at 9:32 PM, Mike Schrag wrote:
% 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 [EMAIL PROTECTED]) AND (isComplete =
0)", arg1);
notice the %% (escaped percent). What could be wrong
with this??
Ted
<[EMAIL PROTECTED]>
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
(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]
-------------- 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 PROTECTED]>
Subject: Re: creating my EOQualifier in code
To: WebObjects-Dev List
<webobjects-dev@lists.apple.com>
Message-ID:
<[EMAIL PROTECTED]>
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 (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/chill%40global-village.net
This email sent to [EMAIL PROTECTED]
--
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 (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]
