[thelist] ASP Addition question

Max Schwanekamp lists at neptunewebworks.com
Mon Jan 15 00:13:56 CST 2007


Beach Computers Web Hosting wrote:
> Ok, all is not well.
> It's rounding the result value.
> Eg: 14.95+15.00=30
> 
> Any ideas?
> 
> <%=CInt(Plans2.Fields.Item("PromoSetupfee").Value)+CInt(Plans2.Fields.Item("
> PromoMonthlyPrice").Value)%>

RTFM.  CInt will convert a float to an integer in VBScript a float 
getting rounded. CInt(14.95) returns 15.  CInt(14.49) returns 14.

If you want to convert numeric strings to floats, it's easiest to use 
Round() with 2 decimal places specified:
<%
Dim a,b
a = Plans2.Fields.Item("PromoSetupfee").Value
b = Plans2.Fields.Item("PromoMonthlyPrice").Value

If Not (IsNumeric(a) and IsNumeric(b)) then
     'handle the error
End If

Response.Write(Round(a,2) + Round(b,2))
%>

http://devguru.com/technologies/vbscript/13907.asp
http://www.w3schools.com/vbscript/vbscript_ref_functions.asp

-- 
Max Schwanekamp
NeptuneWebworks.com
541-255-2171




More information about the thelist mailing list