Re: single quote problem

[Chen, Gin]

Title: RE: single quote problem

I get the error when I forget to supply a username and password for my database connections.

I think Joe is right.. I dont think it has anything to do with the actual statement. I've done queries like that a thousand times and I've never had a problem with them. Check what ur using as parameters for ur database connection. check what the databases syntax for username and password is.

-Tim

-----Original Message-----
From: Jean-Francois Pinero [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 11:43 AM
To: [EMAIL PROTECTED]
Subject: Re: single quote problem

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