Thanks, but I seem to have a problem with the variable
in the expression:
EOQualifier newQual =
EOQualifier.qualifierWithQualifierFormat("(client
caseInsensitiveLike %@) AND (isComplete = 0)", arg1);
if I put the trailing '%' as a wildcard the
expressions fails with:
Reason: Lexical error at line 1, column 32.
Encountered: ")" (41), after : "%"
my sql example... we answered the case insensitivity
but not the wildcard....
select * from adlist where lower(client) like
lower('s%')
maybe I need to escape the trailing %....
Ted
--- David Elliott <[EMAIL PROTECTED]> wrote:
> Theodore,
>
> Try the "caseInsensitiveLike" selector instead of
> the "like" selector.
>
> -Dave
>
> On Feb 24, 2008, at 1:07 AM, Theodore Petrosky
> wrote:
>
> > I don't get this.. I am following the example in
> the
> > Marker book (pg 230).
> >
> > EOQualifier newQual =
> > EOQualifier.qualifierWithQualifierFormat("(client
> like
> > %@) AND (isComplete = 0)", arg1);
> > EOFetchSpecification fs = new EOFetchSpecification
> > ("AsAdSched", newQual, null);
> >
> > This is working fine... I get the resultant data I
> > expect... I am trying to figure out the 'like' and
> > escape for pattern matching...
> >
> > what i want in the SQL is:
> >
> > select * from adlist where lower(client) like
> > lower('s%')
> >
> > it will not matter whether you type upper nor
> lower
> > case....
> >
> > Ted
> >
> >
> >
> >
>
____________________________________________________________________________________
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 protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [EMAIL PROTECTED]
