Re: stringQualifierOperators (like, contains) (David Holt)

Wed, 14 Dec 2005 05:49:12 -0800

David

You should be using something like this for a case insensitive search

EOKeyValueQualifier q1 = new EOKeyValueQualifier("title", EOQualifier.QualifierOperatorCaseInsensitiveLike, mytitle);

Are you using Oracle?  If you are the Contains clause if for the Context Index not the normal VARCHAR index.  And you would have to do see http://developer.apple.com/documentation/LegacyTechnologies/WebObjects/WebObjects_5/Topics/ProgrammingTopics.3a.html.

Which will talk about this.

Creating an EOSQLQualifier with "CONTAINS" (Java)

 EOEntity anEntity=EOModelGroup.defaultGroup().entityNamed("MyEntity"); 
EOSQLQualifier (anEntity, "CONTAINS(columnName,'"+someString+", 1)>0");

Hope this helps.

Paul

Paul
On Dec 13, 2005, at 7:59 PM, [EMAIL PROTECTED] wrote:


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/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to