ok, i am completly new to asp and database development so please bear with me.
i know how to connect to the database and use a record set. But how do i use aggragates with a recordset

Code:
  sql = "select column1 from table1"
  varTest = rs("column1") <---- easy

  sql = "select count(*) from table1"
  varTest = rs("?????") <--- what goes here?