hi damian,
this works for me:
Query query;
Criteria crit;
System.out.println("\nread all persons upper(vorname) = 'JAKOB'");
crit = new Criteria();
crit.addEqualTo("upper(vorname)","JAKOB");
query = new QueryByCriteria(Person.class, crit);
broker.getCollectionByQuery(query);
produces the following sql:
SELECT
A0.isBoss,A0.gebDat,A0.idTest,A0.entryDate,A0.adresse,A0.idPartner,A0.name,A
0.test,A0.vorname,A0.id FROM tabPerson A0 WHERE upper(A0.vorname) = 'JAKOB'
hth
jakob
----- Original Message -----
From: "Damian Alonso" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 08, 2003 2:13 AM
Subject: Case Insensitive queries
Hi,
Does anyone know how to implement case insensitive searching using OJB's
criteria mechanism??
I saw a previous posting which suggested to use
criteria.addEqualTo("upper(name)", "JOHN");
but this gives me an java.lang.StringIndexOutOfBounds() exception
Has anyone else had any success implementing a case insensitive search??
And also, has anyone been able to do case insensitive searching in
conjuntion with wild card searching??
Thanks in Advance
Damian.
> --
> To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
