Code advice; handling nulls

[MikeT]

I pull numbers from a database and do calculations on them in an asp page. These calculations require I check for nulls, which I do by:

if isnull(rs("Price")) then
   varPrice=0
else
   varPrice=rs("Price")
end if

It seems to me there should be a more elegant way of doing this. I know the number field in the db shouldn't be allowing null values, and I could change it, but I want to keep that as a last resort.

Any suggestions?

 

[rtshort]

I'm no expert, but I'd do exactly what you have listed above. Nothing wrong with it in my opinion. Rob
Just my $.02.

 

[trollacious]

So, make your own function to handle it for you:

Function CheckValue(onevalue)

If onevalue = null Then onevalue=0
CheckValue=onevalue
End Function

varPrice=CheckValue(rs("Price&quot)
varNumber=CheckValue(rs("Number&quot)
'etc.