Re: Using an Escaped LIKE Clause

From: Lachlan Deck (lachlan.dec..mail.com)
Date: Wed Jan 27 2010 - 21:06:19 EST

  • Next message: John Armstrong: "Cayenne code generation - pointers requested"

    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 : Wed Jan 27 2010 - 21:07:00 EST