-
recordset help
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?
-
Give it a name using the AS:
Code:
sql = "select count(*) as name1 from table1"
varTest = rs("name1") <--- what goes here?
-
i knew it was something simple, thanks alot!:D