I am trying to count the total number of records I have in the table, which I am using to retrieve information from to display on the ASP website. I know that the SQL code to count the number of records in a table is:
SELECT COUNT (*) FROM Table1
However, I cannot find out how to incorporate this into the ASP VBscript code.
Can anyone help me, please? Thanks