Re: stringQualifierOperators (like, contains)
Re: stringQualifierOperators (like, contains)
- Subject: Re: stringQualifierOperators (like, contains)
- From: Alex Finkel <email@hidden>
- Date: Tue, 13 Dec 2005 21:31:49 -0500
i think that you will make your 'like' qualifier work if you wrap your
search string with the asterisks: *handwashing*
On 12/13/05, David Holt <email@hidden> wrote:
> I am binding the display group stringQualifierOperators to a pop-up
> button so that users can have some option for how they want to search a
> field. The "CONTAINS" qualifier generates SQL such as this:
>
> SELECT t0.evidence_abstract, t0.title, t0.year_publication FROM
> evidence t0 WHERE UPPER(t0.title) LIKE UPPER('%handwashing%') ESCAPE
> '|'
>
> This is exactly the SQL that I would expect for a case insensitive LIKE
> and returns the results expected.
>
> The "LIKE" qualifier generates this SQL:
>
> SELECT t0.evidence_abstract, t0.title, t0.year_publication FROM
> evidence t0 WHERE t0.title like 'handwashing' ESCAPE '|'
>
> This SQL generates no results even though the word handwashing appears
> in 25 titles.
>
> My question is whether the "like" qualifier should even be there?
> "Contains" gives me the results I expect from a "like" query. I can't
> get the "like" query to generate results under any circumstances, yet
> it is exposed as one of the choices to my users and potentially causes
> confusion. Is anyone else running into this? Am I misunderstanding what
> "like" should be returning because of my background using SQL? Is this
> a bug?
>
> Thanks,
> David
>
> _______________________________________________
> 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