For Oracle anyways, inside a prepared statement you could use " ... like '%'
|| ? || '%' ..."
Ryan Rich
----------------
Bitek, Inc.
2569 West Woodland Dr.
Anaheim, CA 92801
(714) 828-8388
----- Original Message -----
From: "Ted Husted" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 31, 2001 12: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/
