Re: Using an Escaped LIKE Clause

From: Andrus Adamchik (andru..bjectstyle.org)
Date: Thu Jan 28 2010 - 03:17:26 EST

  • Next message: Andrus Adamchik: "Re: Cayenne code generation - pointers requested"

    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