1 person found this helpful
This is a stupid bug where CF allows for commas in integers, see
Strongly suggest you ditch <cfinput>, use normal <input> tags and write your own JS (or use a framework) to do the validation.
Also, a couple of things about the code above. The second apostrophe in #'form.name#' is misplaced, it should be before the pound sign. More importantly, directly using form inputs is not at all good. At the least, be sure to use cfqueryparam for all user inputs. Better still, initialize, sanitize, and validate all user input first. Usually, it is best to initialize local variables and then use the values of FORM inputs etc. after validation.
The last part of mkane1's statement cannot be emphasized enough: use cfqueryparam, initialize, sanitize, validate...
To prove the point, disable scripting in your browser and enter the following in the mynumber field (without the quotes): "0 );delete from mytable where (1=1"
You'll be amused by the results -- but I suggest you make a backup copy of your database first!