Entry

Is it possible for me to store the result of a query in a variable?

Jul 17th, 2000 05:16
unknown unknown, Bruce Anwyl

Yes, like this:
sqlStmt = "SELECT Count(Alumni.ID) AS CountOfAlumni
FROM Alumni"
Set rsCount = connDB.execute(sqlStmt)
TotalAlumni = rsCount("CountOfAlumni")
There are <% Response.Write(TotalAlumni) %> registered Alumni.