4 Replies Latest reply on Aug 16, 2002 12:38 PM by L.G.

    Does DinamicQL support  "LIKE"

    L.G. Newbie

      This is the error I got:
      [org.jboss.ejb.plugins.cmp.jdbc.JDBCDynamicQLQuery.InvestmentCompany.ejbSelectGeneric] DYNAMIC-QL: SELECT ic.investmentCompanyId FROM InvestmentCompany ic WHERE ic.investmentCompanyTypeCd <> 'D' AND UCASE(ic.investmentCompanyName) like ?1 AND ic.investmentCompanyTypeCd = ?2 ORDER BY ic.investmentCompanyId
      2002-08-15 02:31:44,649 WARN WARNING:javax.ejb.EJBException: Exception in getInvestmentCompanyList():Error while finding InvestmentCompany: Error compiling ejbql: org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "like" at line 1, column 133.
      Was expecting one of:
      "=" ...
      "<>" ...