Thanks for the tip, Josh...yet another way I'll have to validate an entry. Maybe it's just easier to let them make an illegal entry, then tell them how I want them to enter the data than try to catch all the possible violations...
I wonder what will happen if they enter $1,000 and I run it against IsNumeric(Replace(Form.Dollars, ",","","all")) ? What about that dollar sign? I'll have to see...thanks, Josh... > -----Original Message----- > From: Josh Nathanson [mailto:[EMAIL PROTECTED] > Sent: Monday, March 06, 2006 7:46 PM > To: CF-Talk > Subject: Re: Ok, I give...how can I do this... > > > You could do something like: > > IsNumeric(Replace(form.dollars, ",","","all")) > > That would remove any commas before applying the isNumeric test, so 1,000 > would be rendered as 1000 and pass the test (I think). > > -- Josh ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234362 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
