recordset count, available in ASP

[ruupy]

I've seen a lot of neat count-queries but what if i want to extract the count-result from a simple query in an ASP page....???

Let's say that this :

count (DISTINCT PersNr) from EmpData


...a simple count of all records present (with a non-NULL value for PersNr).

How do i extract the outcome in ASP or do i need a different approach because i want to extract the outcome in ASP,...or do i need to post this question on an ASP-forum?...

RuupY

 

[jhall156]

If you're using ADO then after you execute your query-
In javascript you can do this

If (MyRecordset.Eof = False)
{
MyVar = MyVariable.Fields('yourcolumnname').Value
}
I started out with nothing, and I still have most of it.

 

[rac2]

<%
var qCountEm = &quot;SELECT COUNT(DISTINCT PersNr) AS HowMany from EmpData&quot;;
rsCountEm.open(qCountEm, conn);

var how_many = rsCountEm(&quot;HowMany&quot;).value;
Response.write(&quot;The Number of distinct personnel numbers is: &quot; + how_many)
%>

 

[Guest_imported]

myArray = objRS.GetRows
numCount = UBound(myArray,0)+1