WL5.1- how to write finder for "..upper(field) like upper(txt)"

Discussions

EJB programming & troubleshooting: WL5.1- how to write finder for "..upper(field) like upper(txt)"

  1. hi Frends,

     I want to write a finder method in WeblogicQueryLanguage
     for the below SQL " select * from customer_table where
     upper(cust_name) like upper(%Bill%);"
     Also,if any of U know a good URL abot using WL-QL, with practical code examples,please suggest.
     Thanx in advance

    -Karthik
     
  2. Hi karthik,

    try with this finder query:

      (like cust_name.toUpperCase() ($0).toUpperCase())

    while calling this finder method from the client side u've to append the "%" with the string that u've to search.

    that is ur call will be, home.findCustomer("%Bill%");

    Once this works fine, please reply me.

    thanks...hasan
    (ahamed at aztec dot soft dot net)