I have a table called "Volunteers". I'd like to count the number of entries in this table and then display it on the page.
I've tried adding this code in ASPRunner in the "Events - Add Page Before Display" section. Here is the code that I tried. This works outside of ASPRunner but it clearly doesn't work within ASPRunner. Please let me know what you recommend. Thank you.
[indent]''Goal: Get the Count of Volunteers from the db
''Define the RecordSet, then specify a SQL query and open it
Dim varVolunteers
Dim RS_Count
Set RS_Count = Server.CreateObject("ADODB.Recordset")
RS_Count.Open "SELECT COUNT(FirstName) FROM Volunteers", objConn
''Close the db object at the end of its use
RS_Count.Close
Set RS_Count = Nothing
''Display the Count answer
Response.Write "Number of Volunteers: " & varVolunteers[/indent]