Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Simple question about COUNT (*)

Author  Topic  kgruber Starting Member 6 Posts Posted - 2001-06-19 : 23:11:18 This is probably real simple, but I'm new to this so here's my question... In my asp page i have the following: sql = "SELECT COUNT(*) from table_name" set rs = conn.execute(sql) In all the queries I've written before, I was returning specific fields and used rs("fieldname") to access them. How do I access the results of this query though?