EXTRA INTEGERS IN MY QUERY RESULT

[kingjjx]

Hi, I am querying from an SQL database. I am querying prices for items. How come the results have 3 extra zeros at the end ??..

Eample. 125.22000
184.17000

I looked at the database and it only has 125.22 and 184.17

How do I cut the extra zero's ??
thanks

 

[pigsie]

It may have something to do with the prescision of the column you can set this in enterpise manager I think. Rember you can user numberFormat to format the number when displaying.

HTH

Kola

 

[kingjjx]

Hi, ok .. i figured out that the precision column is set to 5 thats why its adding the extra zeros to make it 5 decimals.

But I cant edit the precision since it will screw up other stuff.

Now, is there anyway in coldfusion where in I can cut out the extra zeros and just set the decimal to 2 integers ?

thanks

 

[NiCoZ]

try this :
#replace(numberformat(yourVariable,"999,999,999,999.00&quot,",","'","all&quot#

 

[Guest_imported]

See my reply to your other post of this question.

By the way, these things are not extra "integers" as you have referred to them. The correct term is "digits". An interger is a whole number. It contain any number of digits. A real number is a number that has both a whole number part and a "fractional" part. It may contain any number of digits, but the digits are not integers.