stringQualifierOperators (like, contains)
stringQualifierOperators (like, contains)
- Subject: stringQualifierOperators (like, contains)
- From: David Holt <email@hidden>
- Date: Tue, 13 Dec 2005 14:51:34 -0800
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