Parameterized LIKE expressions ...

From: Gentry, Michael \(Contractor\) ("Gentry,)
Date: Mon Mar 06 2006 - 16:01:35 EST

  • Next message: Andrus Adamchik: "Re: Parameterized LIKE expressions ..."

    I know I've asked about this a long time before, but I can't recall the
    responses.

    Should a LIKE expression be allowed to have parameterized expressions?
    For example:

    Expression expr = Expression.fromString("name like '$name%'");

    Instead of:

    Expression expr = Expression.fromString("name like '" + name + "%'");

    In my SQL logs for the former, I see:

    LIKE ? [bind: '$name%']

    Not quite what I was trying to accomplish. Of course, you then need to
    consider the issue of the user entering the % sign as part of the text.
    Anyway, If we should allow this, maybe I'll looking into the code when I
    get a chance.

    Thanks,

    /dev/mrg

    This archive was generated by hypermail 2.0.0 : Mon Mar 06 2006 - 16:01:37 EST