JDBC Query

[Makarand Parab]

Hi
I have a delete statement as stated below
String queryParent = "delete from dtree where name = '" + folderName.trim() + "'";

Now foldername can be "Abby's"

should i convert single quote to two single quote like "Abby''s" for query to work properly.

Let me know please asap.

Regards
Makarand Parab

[Maximilian Xavier Stocker]

You can find the answer in the JDBC FAQ on this site

http://faq.javaranch.com/view?JdbcUsageQuestions

Third question:
How do I INSERT or UPDATE a text value with a ' in it