Script ASP - Database: Record Count - Morpheusweb.it - Webmaster resources: programming, asp script, using asp, file asp, asp, asp post, database asp, asp login, vb asp, asp access, asp download, asp script, formmail, area riservata, paginazione, scripts asp, mailform, asp script download

ABOUT >
WORKS >
CONTACT ME >
>

Home Page
> Script ASP
> Script ASP Database
> Record Count

Record Count

To know how many record contains a table.



					
					<% 

					Dim cn,cm 

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

					cn.Open "driver={Microsoft Access Driver (*.mdb)};dbq="& Server.MapPath("Database.mdb") 

					set rs=cn.execute ("Select count(*) as howMany from tabella") 

					response.write "There are " & rs("howMany") & " records in the table"

					cn.close 

					Set cn = Nothing 

					Set rs = Nothing 

					%>