bp_travis
08-08-2007, 09:27 AM
Hello. I have a registration form in ASP that submits to a MySql db. However, when someone puts an apostrophe in their name (O'Conor) it throws off the MySql and spits out an error. How can I use the replace() function to do this. I have tried this
Name=replace(response.form(Name),"'"," ")
but it does not work, the error still comes. Thanks
Name=replace(response.form(Name),"'"," ")
but it does not work, the error still comes. Thanks