Seems like I'll just have to give formatting instructions not to put any commas in a field...on numerals.
But that's not intuitive for someone making an entry for $1,000,000...as 1000000...to difficult to tell how many zeros are there...much easier as 1,000,000 > -----Original Message----- > From: Rick Faircloth [mailto:[EMAIL PROTECTED] > Sent: Monday, March 06, 2006 7:13 PM > To: CF-Talk > Subject: RE: Ok, I give...how can I do this... > > > You know...I tried using IsNumeric(Val(Form.Dollars)), > but found it was identifying a field entry of "wlekfjwlek" > as numeric...I assume it was assigning a value of "0" > to the entry and that is numeric... > > So that didn't weed out that kind of junk field entry > in my validation (which is what I'm working on here... > trying to validate an entry as a valid dollar entry. > > Rick > > > > -----Original Message----- > > From: Mike Kear [mailto:[EMAIL PROTECTED] > > Sent: Monday, March 06, 2006 7:00 PM > > To: CF-Talk > > Subject: Re: Ok, I give...how can I do this... > > > > > > No. numeral 1, comma, zero zero zero is a text string. But if > you want to > > make it a numeric value you can use #val("1,000")# . The > > val() function > > attempts to make a number out of whatever is in the string > > submitted to it. > > > > Cheers > > Mike Kear > > Windsor, NSW, Australia > > Certified Advanced ColdFusion Developer > > AFP Webworks > > http://afpwebworks.com > > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > > > > > On 3/7/06, Rick Faircloth <[EMAIL PROTECTED]> wrote: > > > > > > Should a field entry of "1,000" validate > > > as a numeric? > > > > > > e.g. IsNumeric(Form.Dollars) > > > > > > (Where Form.Dollars has a value of "1,000) > > > > > > Rick > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:234346 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54