"DESC" is a reserved word - sorts the affected rows.
alter the table, use an other fieldname,
dirk
----- Original Message ----- >
<snip/>
>conn.prepareStatement("SELECT FROM PRODUCTS WHERE DESC
> = (?)");
> pstmt.clearParameters();
> pstmt.setString(1, index);
> ResultSet rs = pstmt.executeQuery();
>
> }
>
> Thanks
> Rui
</snap
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
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
