Use "likeIgnoreCase" instead of "like" ...
On Thu, Mar 26, 2009 at 11:19 PM, John Armstrong wrote:
> I couldn't quite get the EJBQL syntax right so I ended up using fromString
>
> Expression qual = Expression.fromString("code like $license and
> claimedunits < totalunits");
>
I couldn't quite get the EJBQL syntax right so I ended up using fromString
Expression qual = Expression.fromString("code like $license and
claimedunits < totalunits");
java.util.Map params = new java.util.HashMap();
params.put("license", licenseCode.
Hi John,
You should try EJBQL:
select t0 from License t0 where t0.claimedunits < t0.totalunits AND
http://cayenne.apache.org/doc/ejbqlquery.html
2009/3/26 John Armstrong
> Hi, I need to do a selection on a table partially based on comparing
> two elements
> of that table. Basically a 'tot
Hi, I need to do a selection on a table partially based on comparing
two elements
of that table. Basically a 'total' and a 'current' where total is a
changing value and needs to be compared to current to see if the row
is valid. Its a floating license system for an app I am building.
This obviousl
