[prev in list] [next in list] [prev in thread] [next in thread]
List: struts-user
Subject: Re: LIKE with PrepareStatement
From: "Jeff Trent" <jtrent () structsoft ! com>
Date: 2001-05-31 20:05:51
[Download RAW message or body]
Ted,
I am assuming your query uses bind variable and you already know that
offsets start with 1, and not 0. So besides that, the way I would get
around this is by doing something like this:
searchStr += "%" + searchStr + "%";
String strSql = "select x from y where y.z like ?";
ps.setString(1, searchStr);
----- Original Message -----
From: "Ted Husted" <husted@apache.org>
To: <struts-user@jakarta.apache.org>
Sent: Thursday, May 31, 2001 3:58 PM
Subject: OT: LIKE with PrepareStatement
> Not directly Struts related, but anyway, I'm trying to use "LIKE '%?%'"
> as part of a prepared statement, but it's coming back invalid array
> index. Apparently, the symbols are hiding the question mark. Anyone know
> a way around this, besides doing the substitution and escape-coding the
> old-fashioned way?
>
> -- Ted Husted, Husted dot Com, Fairport NY USA.
> -- Custom Software ~ Technical Services.
> -- Tel 716 737-3463.
> -- http://www.husted.com/about/struts/
>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic