ResultSet ivRs = con.createStatement().excuteQuery(select x_id from tbl_y where fname like '%" + param + "%'");
It works as expected
How to I implement this as a prepared statement ?
An alternative sollution to what Christan suggested should be: ... WHERE fname LIKE '%' & ? & '%'
& is the Operator to concat Strings. I haven't tested that, but it might work, but i would also prefer the sollution that Christian suggested.
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
