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
>
>
>
>
This archive was generated by hypermail 2.0.0 : Thu Jan 28 2010 - 03:18:02 EST