Not all asp, problem about page submitting to asp.

[FVH3]

Hi,
I have an html page with a simple form (a few textboxes, nothing more) which I can succesfully pass through to an asp page which inserts the data into a database. However there is a problem; if someone put a quote mark (') into the text box and clicks submit it won't work (it interferes with either the asp or sql code, I can't remember which).

Anyway, my question is, is there a way to replace the quote marks with something else on the html page, or perhaps on the asp page - whichever will make it work? Something like a replace("'", "''&quot or something.

Thanks in advance,
FVH3

 

[9210]

Hi FVH3
Can you post the ASP and SQL code for teh said problem. It looks like it is getting stuck with the SQL code....

rgds,
9210

 

[FVH3]

Thanks but I found out how to fix it. I use a replace(string, "'", "''&quot before passing it through the SQL.