SQL Syntax - COUNT(*)

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   If you are counting the ammount of records in the table you should do something like this;

Set testing = Server.CreateObject("ADODB.Recordset")

strSQL = "SELECT COUNT(id) AS myc FROM table;" 

testing.Open strSQL, adoCon

Response.Write(testing("myc"))

---- Or ----

Set testing = Server.CreateObject("ADODB.Recordset")

strSQL = "SELECT COUNT(id) myc FROM table;" 

Set testing = adoCon.Execute(strSQL)

Response.Write(testing("myc"))

This is how you should count, and if your column (id) is indexed, the count will be extremely fast.