I think I know there is no way but to write my own routine, but if I do, maybe someone has done it before...
How can I check to see if a text form field contains anything other than numbers? CFINPUT/VALIDATE won't do, here's why: This system deals with a lot of big dollar amounts - $3,500,000.00 - etc - So to improve readability on editing them, I put them in the VALUE=#dollarFormat(var)# of the CFINPUT, but whether they change them or not, when they process the CFFORM, it would cause an error if the field was type=float or integer... So, I made them type=text and parse out the $ and/or commas in a loop myself. But if they "oops" and put $3,5T0,000 or OH instead of zero or whatever, they would get the ODBC ERROR "tombstone" error page. Is there a simple test to see if a text field will go into the database in a numeric field, so I can loop back with a message to the user (as I already do for other purposes)? FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
