Ok, that makes sense. Will have a look and see why it thinks it is not a number.
Got it working now. Thanks all :) -----Original Message----- From: Stephen Moretti [mailto:[EMAIL PROTECTED]] Sent: 12 February 2003 17:20 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] brain fluff Douglas, CF is typeless, but not that typeless! A number with a comma or currency sign is a string, not a number. Care of Taz : <cfset MyNumber = ReReplace(MyNumberAsAString, '[^\.|0-9]{0,}', '', 'ALL')> This will remove all the stuff that isn't numeric and leave you with purely a number. Regards Stephen ----- Original Message ----- From: "Douglas McKenzie" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 12, 2003 5:05 PM Subject: RE: [ cf-dev ] brain fluff > Same error. It seems to be thinking that coz theres a comma in it, its not a > number. Is therea function where you can convert decimalformat back to > numberformat? > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] > Sent: 12 February 2003 17:01 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] brain fluff > > > > what about: > > <cfset nCurrEUR = intTotal*Rate> > > > Duncan Cumming > IT Manager > > http://www.alienationdesign.co.uk > mailto:[EMAIL PROTECTED] > Tel: 0141 575 9700 > Fax: 0141 575 9600 > > Creative solutions in a technical world > > ---------------------------------------------------------------------- > Get your domain names online from: > http://www.alienationdomains.co.uk > Reseller options available! > ---------------------------------------------------------------------- > ---------------------------------------------------------------------- > > > > > "Douglas > McKenzie" To: "CF-Dev" > <[EMAIL PROTECTED]> > <doug@clevermonk cc: > eys.co.uk> Subject: [ cf-dev ] brain > fluff > > 02/12/03 04:59 > PM > Please respond > to dev > > > > > > Weird little problem going on here: > > <cfset nCurrEUR="#evaluate(intTotal*Rate)#"> > > This works fine until intTotal becomes > 1000. I then get this error > message > The value "10,200.00" cannot be converted to a number. > > Any ideas? > > Cheers, > Douglas McKenzie > > ---------------------------------------- > Internet Developer / Designer > [EMAIL PROTECTED] > 020 7267 6718 > ---------------------------------------- > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
