Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

finder

 
John Faulk
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 18094
48
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic