From: Date: July 30 2004 4:47am
Subject: Ignoring or filtering ' char
List-Archive: http://lists.mysql.com/win32/15280
Message-Id: <20040730024710.7580.qmail@web60208.mail.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

hi

i'm using Java to write a program that access mysql
database. here's a part of the java program source
code:

---------------------------------------------------------
query = "insert into userinfo values ('" +
emailSubject + "');";
executeUpdate(query);
---------------------------------------------------------

basically what the program does is it will insert an
incoming email's subject into a mysql table.

the problem occurs when the subject has the character
' in it. For example if the subject is something like
:"You've got a mail",mysql will give an exception
which looks something like this:

------------------------------------------------------
java.sql.SQLException: Syntax error or access
violation,  message from server: "
You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version
for the right syntax to use near 've got

','Fri Jul 30 10:11:04 GMT+08:00 2004')' at line 1"
------------------------------------------------------
from what I can see MySql treats the ' char as part of
mysql syntax. how can i overcome this problem? any
help are greatly appreciated.

Thanx.





	
		
__________________________________
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail