2 possible solutions :
1. There are no rows selected or
2. Shouldn't it be : getSearchStmt.setString(1,searchstring) ?
----- Original Message -----
From: sufi malak <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 01, 2000 7:28 PM
Subject: sorry, sql question ???
> 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
===========================================================================
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
