thanks Joe,
sometimes one just can't see a small problem unless someone
reminds him.
You are right that i missplelled the name of two fields.But i
have never thought "two few parameters" would mean that.
Wouldn't be nicer if it threw a "..... field couldn't be
found" ? instead of a confusing "two few parameters " error
message.
anyway thanks for your help
cheers :)
-----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
