Hi
Can anyone tell me where I can find a script that tells you the number of records that have been found by a db search, or can the code below be adapted to count only the records found??
<%DIM mySQL, objRS
mySQL = "SELECT Count(*) AS intTotal FROM tblmembers"
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS = conn.Execute(mySQL)
' Display result
Response.Write "Number of Members Currently in The Database is "
Response.Write objRS("intTotal")
objRS.Close
set objRS = Nothing
%>
Thanks in advance for any help
Ken
Topic Options
Post Options
Thanks(0)
