I'm trying to display a query in ASP. The qeury looks something like this:
SELECT Count(CallNum) AS TotalCalls, Sum(CallLen) AS TotalLength, AdvNumber FROM CallLogs GROUP BY AdvNumber;
For some reason, when I try to get the value of TotalCalls, I do not get a numerical value and cannot perform any calculation on it, but TotalLength is ok. Why does Count return a non numerical value?
SELECT Count(CallNum) AS TotalCalls, Sum(CallLen) AS TotalLength, AdvNumber FROM CallLogs GROUP BY AdvNumber;
For some reason, when I try to get the value of TotalCalls, I do not get a numerical value and cannot perform any calculation on it, but TotalLength is ok. Why does Count return a non numerical value?