Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Count(Field) does not return a numerical value in ASP

Status
Not open for further replies.

siftach

Programmer
Jul 22, 2003
78
IL
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?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top