Escaping single quote in string

[jlynch1]

How do I replace a single quote ' with two single quotes '' so I can insert information from a form into a text field in an MS Access database.

The replace method of string only lets me replace a single character with a single character...

How can I get around this ??

 

[petey]

Use java.lang.String's replaceAll() method.

http://java.sun.com/j2se/1.4.1/docs...eplaceAll(java.lang.String, java.lang.String)

Hope this helps!

petey

http://www.drpeterjones.com/

 

[jlynch1]

how would I specify a single quote as a regular expression as required by that function.

public String replaceAll(String regex, String replacement)

 

[petey]

foo = foo.replaceAll("'","''"

easy beans...

http://www.drpeterjones.com/

 

[Hattusas]

A better solution is to use PreparedStatement.
e.g.
java.sql.Connection conn = ......

java.sql.PreparedStatement ps=conn.prepareStatement("insert into mytable (field1,field2) values (?,?)0);
ps.setString(1,yourclass.getYourField1());
ps.setString(2,yourclass.getYourField2());
ps.executeUpdate();
If you use PreparedStatement instead of Statement there is no need care about ' or '' s.
Salih Sipahi
Software Engineer.
City of Istanbul Turkey
ssipahi@yonbilgi.com