sql count

hur gör jag så

SELECT COUNT(column) FROM table

skrivs ut med hjälp av asp??
skriver man

<% SELECT COUNT(column) FROM table %>

händer ju ingenting.

sql = "SELECT COUNT(c) FROM t"
set rs = connect.execute(sql)
response.write "Antal = " & rs(0) & "<br>"

eller

sql = "SELECT COUNT(c) as f FROM t"
set rs = connect.execute(sql)
response.write "Antal = " & rs("f") & "<br>"

tackar LarsG!!