Skip to main content
Known Participant
October 19, 2010
Answered

apostrophe ASP form

  • October 19, 2010
  • 1 reply
  • 622 views

Hi,

I have got a form that allows people to book for an event. This data also gets saved into a database. When people type in an apostrophe they receive an error. What is the best way to insert an apostrophe into a database via a form?

I am using asp.

Hope someone can help!

Thanks

This topic has been closed for replies.
Correct answer bregent

Use Replace() to replace each single quote character with 2 single quote characters.

1 reply

bregentCorrect answer
Participating Frequently
October 19, 2010

Use Replace() to replace each single quote character with 2 single quote characters.

dips045Author
Known Participant
October 20, 2010

Thank you very much :-D