double quotes and number symbol are stripped out when submitting text data into SQL DB
Posted on 2004-08-03
I have a form with a text box. When the user submits the form and reviews the submitted text in a browser the double quotes and # symbol that was submitted in the form is stripped out. When the data is inserted into an SQL db table these symbols are removed as well.
Right now my code is:
<cfset form.attr=REREPLACENOCASE(form.attr,"[^(a-z|0-9|,|'|:|.|?|!|$|%|*|+|=|;|\-|\"")]"," ","ALL") >
but I can't get the double quotes and number symbol to be excepted.