SQL Syntax - COUNT(*)

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

   Very easy question. What is wrong? Why I get "-1" If table have some record?

Dim aaaa

Set adoCon = Server.CreateObject("ADODB.Connection")

adoCon.Open = "Provider=Microsoft.Jet.OLEDB.4.0; 

Data Source=" & Server.MapPath("testing.mdb")

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

strSQL = "SELECT COUNT(*) FROM table;" 

testing.Open strSQL, adoCon

 aaaa = testing.RecordCount

 Response.Write aaaa

testing.Close

Set testing = Nothing

Set adoCon = Nothing

Edited by faca5 - 12 December 2005 at 6:07am