Lachlan is correct. Escaping is only supported in EJBQL now:
SELECT p FROM Painting p WHERE p.paintingTitle LIKE 'X_DDDD' ESCAPE
'X'
Should be more or less straightforward to add it to Expressions I guess.
Andrus
On Jan 28, 2010, at 4:06 AM, Lachlan Deck wrote:
Hi Andrew,
On 28/01/2010, at 12:41 PM, Andrew Lindesay wrote:
Hello;
A question about escaping a LIKE qualifier;
ExpressionFactory.likeExp(...,...)
JDBC specifies the ability to use '%' and '_' as matchers for
characters and a character respectively. It is then possible to
escape use of those characters as in the following example;
SELECT a FROM tabA WHERE a LIKE '%=_' {escape '='}
I can't easily see a means by which one can specify the "escape"
clause in a SelectQuery -- can anybody shed some light on this for
me.
I'm sure Andrus and other committers will respond in time (being in
a differing timezone)... but if SelectQuery doesn't do it, you might
be able to do so with EJBQL.
with regards,
--
Lachlan Deck
