Need Help with an SQL Select Statement

[kevinj]

I have a database that has a table called exhibitors. I need to write a select statement that counts the number of records in that table and then use a Response.Write statement to display that number. Any ideas would be greatly appreciated.

[wardbekker]

"Select Count(*) As TotalExhibitors From exhibitors"

Response.write oRecordset("TotalExhibitors")

(assuming you created an oRecordset that contains the result of the sql statement)

[kevinj]

Thanks wardbekker. Works perfectly.

[txbakers]

You can also use the oRecordset.RecordCount command if you set the cursor correctly. I don't recall the specific terms, but I set mine to all 3s and you can use the RecordCount. That way you don't need a separate query to get the count.