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
posted 15 years ago
im sure our moderator knows the answer for that one !