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 PROTECTED]> 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 protected])
> Help/Unsubscribe/Update your Subscription:
> http://lists.apple.com/mailman/options/webobjects-dev/finkel.alex%40gmail.com
>
> This email sent to [EMAIL PROTECTED]
>
_______________________________________________
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]
