Re: creating my EOQualifier in code
Re: creating my EOQualifier in code
- Subject: Re: creating my EOQualifier in code
- From: Theodore Petrosky <email@hidden>
- Date: Sun, 24 Feb 2008 21:28:31 -0800 (PST)
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