cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Using an Escaped LIKE Clause
Date Thu, 28 Jan 2010 08:17:26 GMT
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
>
>
>
>


Mime
View raw message