I thought "too few parameters" meant you are not passing enough variables...
-----Original Message-----
From: Joe Cheng [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 11:37 AM
To: [EMAIL PROTECTED]
Subject: Re: single quote problem
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
