This content has been marked as final.
Show 4 replies
-
1. Re: Does DinamicQL support "LIKE"
l.g. Aug 15, 2002 11:07 AM (in response to l.g.)When I modified dynamic query to use literal with "LIKE" it's still give me the same error.
=============================================
SELECT ic.investmentCompanyId FROM InvestmentCompany ic WHERE ic.investmentCompanyTypeCd <> 'D' AND UCASE(ic.investmentCompanyName) LIKE 'A%' AND ic.investmentCompanyTypeCd = ?1 ORDER BY ic.investmentCompanyId
==============================================
This is a bug, I think. Is anybody using DynamicQL with "LIKE"? (Is anybody wants to use DynamicQL with "LIKE"?) -
2. Re: Does DinamicQL support "LIKE"
l.g. Aug 15, 2002 11:15 AM (in response to l.g.)Forgot to include jboss version:
3.0.1 Date 200208062340
TIA -
3. Re: Does DinamicQL support "LIKE"
dsundstrom Aug 16, 2002 1:09 AM (in response to l.g.)You can't use a function in the like clause. You should be able to do this, but I forgot to add it to the grammer. Can you file a feature request at source fourge on this?
-