Doesn't "too few parameters" usually mean you've spelled one of the table/field names incorrectly? Are you sure it's the single quotes that's the problem... try removing the WHERE clause entirely.
There's no reason your code shouldn't work, unless the variable search itself contains single quotes, in which case you should escape them to two single quotes--or use PreparedStatement, as Jan said. -jmc =========================================================================== 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://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
