This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » EJB and other Java EE Technologies
Bookmark "finder" Watch "finder" New topic
Author

finder

John Faulk
Greenhorn

Joined: Feb 05, 2001
Posts: 4
hi,
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: 15959
    
  19

It looks like you'll have to write a Java finder to do your case conversion:
http://www.weblogic.com/docs51/classdocs/API_ejb/EJB_environment.html#1023038

Customer surveys are for companies who didn't pay proper attention to begin with.
 
wood burning stoves
 
subject: finder
 
Similar Threads
case insensitive search in finder
How to write this find Query Element
Little Thing about ejb QL
How to Entity Beans in Jboss !
Alternative to LIKE Clause