Answered
Validation with Regular Expressions
I am trying to validate data using regular expressions.
here is a copy of the code.
<cfinput type="text" name="FQID_#ATTRIBUTES.FQID#_officer" width="36" validate="regular_expression" pattern="^\bna\b$|^\d*[0-9](|.\d*[0-9]|,\d*[0-9])?$" required="#ATTRIBUTES.required#" enabled="yes" message="0.0 to 100 or na, Required" value="#ATTRIBUTES.FQID_Response.Officer#" style="textAlign:right;" onchange="removeDash(FQID_#ATTRIBUTES.FQID#_officer);"/>
I do not get any errors but I am still able to enter anything I want into the text box. I am trying to limit it to a number between 0 and 100 and excepts decimal amount. It also needs to accept na if it is not applicable. As it stands now I can enter anything.
here is a copy of the code.
<cfinput type="text" name="FQID_#ATTRIBUTES.FQID#_officer" width="36" validate="regular_expression" pattern="^\bna\b$|^\d*[0-9](|.\d*[0-9]|,\d*[0-9])?$" required="#ATTRIBUTES.required#" enabled="yes" message="0.0 to 100 or na, Required" value="#ATTRIBUTES.FQID_Response.Officer#" style="textAlign:right;" onchange="removeDash(FQID_#ATTRIBUTES.FQID#_officer);"/>
I do not get any errors but I am still able to enter anything I want into the text box. I am trying to limit it to a number between 0 and 100 and excepts decimal amount. It also needs to accept na if it is not applicable. As it stands now I can enter anything.
