Click to See Complete Forum and Search --> : odbc select ..like ?


yna54
October 1st, 2000, 12:37 PM
Hi, , I spent long time but it does not work :
PreparedStatement getSearchStmt;
String getchilds = "select * from MP5_CONCEPT_DEPENDENCIES where PARENT_ID=?";
getSearchStmt.setString(1,"'% + searchstring + %'");

But it does not return nothing, I don't know if what I am doing is correct or not.
Thanks

SkyM
October 2nd, 2000, 08:44 AM
May be you should write your select statement like:

"SELECT * from EMPLOYEE WHERE FIRST_NAME LIKE 'A%'

This worked under MS SQL, ORACLE and Sybase.

Gurinder Grewal
October 3rd, 2000, 02:09 PM
The following should work:

String getchilds = "select * from MP5_CONCEPT_DEPENDENCIES where PARENT_ID LIKE ?";
getSearchStmt.setString(1, "'%" + searchstring + "%'");