Get floating number

[dexeloper]

I'm reading a recordset from a SQL Server procedure. One of the columns is type float but when I get it back into my ASP code I'm losing precision of the last few digits.

An example is 1125899906863598.0 which becomes
1.1258999068636E+15

Using FormatNumber doesn't help - the last few digits have somehow been lost.

Any ideas?

 

[FesterSXS]

try using CDbl(objRS("myFloatNumber"))

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[dexeloper]

Done that. It gives 1125899906863600

 

[FesterSXS]

do you need it to be a number in your ASP or are you just displaying it as text? If it is just appearing as text then try converting it to a string using CStr()

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation

 

[DotNetGnat]

show us your sample data and how do you want it to look on your asp page...

you may use round() in your sql...

-DNG

 

[dexeloper]

Think I've cracked it.
Changed the definition in SQL Server from 'float' to 'bigint'. Casting it as varchar then preserved the lower digits. Then brought it into ASP and converted to double.

 

[FesterSXS]

well done - thanks for posting your solution for others to see

Tony

Spirax-Sarco - steam traps control valves heat exchangers
Sun Villa - Luxury Florida accommodation