recordset help

[ATommasi]

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

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

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

[JoshT]

Give it a name using the AS:

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

[ATommasi]

i knew it was something simple, thanks alot!