Hey guys, I just need some feed back on how to treat prices as far as forms and adding them to the database.
Basically, how do you do it? Right now I have a field in my database with the data type of MONEY. This field will hold the price of a property. It seems that the db only like numeric values being added into that field, which makes sense. So how do you guys validate and make sure your users put in only numeric values and that they don't add any $ or , into the form fields? Do you do JavaScript to check before the form is submitted, or do you just use a ColdFusion Replace function and remove all invalid characters before they are submitted to the query? Thanks, Ryan ---------------------------------------------------------- To post, send email to [email protected] To unsubscribe: http://www.dfwcfug.org/form_MemberUnsubscribe.cfm To subscribe: http://www.dfwcfug.org/form_MemberRegistration.cfm
