finder
John Faulk
Greenhorn
Posts: 4
posted 16 years ago
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?
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?
posted 16 years ago
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
http://www.weblogic.com/docs51/classdocs/API_ejb/EJB_environment.html#1023038
An IDE is no substitute for an Intelligent Developer.
