Discussion:
Removing commas from number string
(too old to reply)
PaulH *TMM*
2006-01-23 11:01:45 UTC
Permalink
multiplied. this problem only occurs when there is a comma in the number. how
do i remove it before it is inputted in the database? help is greatly
<cfscript>
aValue=" 1,450";
writeoutput(" #aValue# ::: #lsParseNumber(aValue)#<br>");
</cfscript>

you might also just validate it's numeric in the form clientside.
zidane511
2006-01-23 12:40:52 UTC
Permalink
Paul,

Thanks so much for your help!! The LSParseNumber did the trick. i placed that
before inputting the number in the database:

#LSParseNumber(#FORM.unitPrice#)#

i overlooked that function....thanks so much for your time. I greatly
appreciate it.

-Nadjib

Loading...