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 02:36:42 -0800 (PST)
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@hidden> 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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden