String verses Integer for + operator

[uva2000grad]

I've run into a typing problem in vbscript ( imagin that)
I've got some values in a DB that I need to sum. They are BOTH Number types in Oracle. I have a function called DescNumber that converts NULLS to 0 and any other numbers it performs a Cdbl() on the variable.
The expression:
DescNumber ( Value1) + DescNumber( Value2 ) return 10 if value1 = 1 and value2 = 0 ie STRING concatenation!
but if it's written
DescNumber( Value1 + Value2 ) it returns 1.

What am I missing???? Thanks ahead of time.

 

[JohnYingling]

Try moving CDBL(0) when replacing NULL (If you haven't already).

http://WWW.VBCompare.Com

 

[uva2000grad]

I tried that- I seems that CDBL(2300) returns 2,300. IS that considered a string?

 

[foxbox]

this works oke with my version (6 SP4):

<%@ Language=VBScript %>
<%
function DescNumber
if isnull then
DescNumber = Cdbl(0)
else
DescNumber = Cdbl
end if
end function

Response.Write DescNumber(1) + DescNumber(0) & &quot;<br>&quot;
Response.Write DescNumber(2300) + DescNumber(700)
%> br
Gerard

 

[uva2000grad]

Hey Foxbox- are you useing IIS 5? I'm stuck with 4. Thanks.

 

[shaddow]

Why dont u try to use Int function
int(DescNumber ( Value1)) + int(DescNumber( Value2 ))
________

George

 

[uva2000grad]

I'd really like to use the CLNG() function because it doesn't seem to insert the &quot;,&quot;- but the values I am working with can be over 2,147,483,647 so I need to use CDBL().

 

[foxbox]

>Hey Foxbox- are you useing IIS 5
Yep. And SQL Server 7, all under Win2K. br
Gerard