Division By Zero.....when it's not zero!!!

[mattygriff]

Please look at the following code :

<%
if intWickets = 0 then
decBowlAv = 0
else
[COLOR=red]decBowlAv = formatnumber((intRuns/intWickets),2)[/color]
end if
response.write decBowlAv
%>

</td>
<td width="50"><h6>
<%
intBallsBowled = (int(decOvers)*6) + intTotBalls
if intBallsBowled = 0 then 
decStrikeRate = 0
else
[COLOR=red]decStrikeRate = formatnumber((intBallsBowled/intWickets),2)[/color]
end if
				
response.write decStrikeRate
%>

I have highlighted two calculations in red. The first one works OK but the second returns a "division by zero" error.

How can this be when they both use the same denominator???

 

[FesterSXS]

Yes they use the same denominator but the 1st one only runs when intWickets doesnt equal 0. The 2nd one will execute if intWickets equals 0. Maybe you should put the same conditional code in the 2nd one that you have in the 1st.


Tony

http://www.SpiraxSarco.com

 

[BarkingFrog]

You're getting this error because intWickets = 0.

if intBallsBowled = 0 then
decStrikeRate = 0
else
If intWickets > 0 Then
decStrikeRate = formatnumb((intBallsBowled/intWickets),2)
End If
end if