Hi,
I am guessing that you do not want to do a exact match from the
setString (blah '%' blah) you are doing. For this you should not
use "=" in the SQL statement, but rather use "like". So your
SQL statement would be something like:
"select * from MP5_CONCEPT_DEPENDENCIES where PARENT_ID like ?"
At 07:28 PM 2000/10/01, sufi malak wrote:
>Hi, sorry, I know this is for jsp not for sql, 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
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at
>http://profiles.msn.com.
>
>===========================================================================
>To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
>JSP-INTEREST".
>Some relevant FAQs on JSP/Servlets can be found at:
>
>http://java.sun.com/products/jsp/faq.html
>http://www.esperanto.org.nz/jsp/jspfaq.html
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
>http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
-Deon
------------------------------------------------------------------
Cellpoint SA (Pty) Ltd. | GSM data communication solutions
http://www.cellpt.co.za | http://labs.cellpt.co.za/~deon
Voice: +27-(0)11-254-5100 | Fax: +27-(0)11-805-6053
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
