apostrophe ASP form

[dips045]

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

[bregent · Accepted solution]

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

[dips045]

Thank you very much 😄