Apostrophe Problem in String

[Gregg Bolinger]

among many other fields, I have a text area that I am getting and entereing into an SQL database. The problem is that if you use a contraction like CAN'T or DON'T or WON'T, in other words, inlcuding an apostrophe in the text field, SQL throws an exception because String literals are added to the DB using ' '. Does anyone know of a work around without telling the users they can't use certain characters in typing?
Thanks

[Roy Ben Ami]

im sure our moderator knows the answer for that one !

[Gregg Bolinger]

Actually, I figured it out. PreparedStatement instead of Statement.

[David O'Meara]

Originally posted by Roy Ben Ami:
im sure our moderator knows the answer for that one !

Hmm, trouble maker, eh?
You could just paste a link instead

(If you did a search on my name a PreparedStatement you'd probably get stacks of hits. What can I say, I'm a fan. )

[Roy Ben Ami]

sorry David, i only meant it as a freindly joke.
no pan intended.
point taken.

[David O'Meara]

and I completely took it as a friendly poke!
No stress caused!

Dave.