File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes EJB and other Java EE Technologies and the fly likes finder Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "finder" Watch "finder" New topic


John Faulk

Joined: Feb 05, 2001
Posts: 4
i could not find a way i can use the equivalent of sql UPPER and LOWER in ejb query language.
basically if i have a 'employee' table with column 'name' and 1 entry for Jack.
if the user searches for 'jack' , i should return the row.
but the finder-query does not allow me to use anything but the below:
<finder-query>< ![CDATA[(like name $0)]]></finder-query>
so unless i store the table data in lowercase or uppercase (which i don't want to), i cannot do a case-insensitive search.
advise anyone?
Tim Holloway
Saloon Keeper

Joined: Jun 25, 2001
Posts: 16308

It looks like you'll have to write a Java finder to do your case conversion:

Customer surveys are for companies who didn't pay proper attention to begin with.
I agree. Here's the link:
subject: finder