MySQL Post Textarea Problem

[kyd]

I'm new to application development. I have a web based form that contains a text area. When someone types there information into the textarea it is posted to the MySQL database with no problem. However, if someone copy and paste text that contains single or double quotes into the textarea I get errors. Please help!!!!

[fileserverdirect]

Are you using php?
if so try adding this to the page:

<?
$submitted_string = addslashes($submitted_string);
//with $submitted_string being the sting that contains the message.
?>

that should escape the quotes.
If you have a problem, please ask

[kyd]

No, I'm actually using java. Do you have anything to escape the quotes using java?

Thanks.

[fileserverdirect]

Im am not really a java person, but try this:

import java.util.*; 
public class quote{ 
public String addSlashes(String str){ 
if(str==null) return ""; 
StringBuffer s = new StringBuffer ((String) str); 
for (int i = 0; i < s.length(); i++) 
if (s.charAt (i) == '\'') 
s.insert (i++, '\\'); 
return s.toString(); 
} 
public static void main(String args[]) { 
quote qt=new quote(); 
System.out.println(qt.addSlashes("the message's varable here")); 
} 
}

untested.

[kyd]

Thanks. I will try this out when I get back to work. Thanks again.