Re: LIKE with PrepareStatement

2001-05-31 Thread Ryan Rich
;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&#

Re: LIKE with PrepareStatement

2001-05-31 Thread Jeff Trent
t x from y where y.z like ?"; ps.setString(1, searchStr); - Original Message - From: "Ted Husted" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 3:58 PM Subject: OT: LIKE with PrepareStatement > Not directly Struts related, but anyway,

OT: LIKE with PrepareStatement

2001-05-31 Thread Ted Husted
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