<div>
You can use javascript to validate on the client side, and CF replace() or a regex replace to revalidate on the server side.<br />
<br />
But first we need to know which characters you want to allow/disallow. Use whichever set is smaller. <br />

</div>


You can use javascript to validate on the client side, and CF replace() or a regex replace to revalidate on the server side.

But first we need to know which characters you want to allow/disallow. Use whichever set is smaller.


<div>
AGX: &nbsp;I'm not sure about a set of charcters, however, I do know that single &amp;&nbsp;double quotes have created problems when they have been passed on to the datafields.
</div>


AGX:  I'm not sure about a set of charcters, however, I do know that single & double quotes have created problems when they have been passed on to the datafields.

<div>
<div class="content wysiwyg-content">
Can someone tell me how to add code to a cf web form that will dis allow certain characters from being entered into the form fields. &nbsp;The form data is dumped into a 2005 SQL Server database. &nbsp;I need to prohibit certain characters, i.e. single quotes, from being entered. &nbsp;I assume you use some kind of form validation but I'm not sure how to do it.
</div>
</div>


Can someone tell me how to add code to a cf web form that will dis allow certain characters from being entered into the form fields.  The form data is dumped into a 2005 SQL Server database.  I need to prohibit certain characters, i.e. single quotes, from being entered.  I assume you use some kind of form validation but I'm not sure how to do it.

ColdFusion Code Validation

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.