I don't know if anyone else has seen this happen with the masking option in cfinput. When i use the following code it inserts correctly into the DB, but when it retrieves the information from the DB it adds more numbers.
Now if you put a random number like 123 it goes in correctly, but comes out 1230000. It adds more zeros. I should say it adds more zeros IF i request it to display in the form itself (edit mode), but if i use a cfdump or output of the rewards in the DB it displays correctly. So i know it's the masking option and can't figure out how to fix it. I just want make sure people insert numbers and no letters or symbols.