URGENT(COUNTING OF RECORD IN DATAABSE USING ASP)

[Daniel Ng]

Hi all, may i know how to write a simple code using asp to count the
number of record in the Access and display the figure out... Thanks...

 

[Ray Costanzo [MVP]]

<%
Dim oADO, oRS, sSQL
sSQL = "SELECT COUNT(UniqueID) FROM tableName"
Set oADO = CreateObject("ADODB.Connection")
oADO.Open "your connection string, www.connectionstrings.com"
Set oRS = oADO.Execute(sSQL)
Response.Write "Record count is " & oRS.Fields.Item(0).Value
oRS.Close : Set oRS = Nothing
oADO.Close : Set oADO = Nothing
%>

Some will say to do a COUNT(*). I personally count a column that I know
will never have any nulls, such as whatever is the primary key in the table.

Ray at work

 

[Tom Kaminski [MVP]]

Hi all, may i know how to write a simple code using asp to count the
number of record in the Access and display the figure out... Thanks...

http://www.aspfaq.com/show.asp?id=2193

--
Tom Kaminski IIS MVP
http://www.microsoft.com/windowsserver2003/community/centers/iis/
http://mvp.support.microsoft.com/
http://www.iisfaq.com/
http://www.iistoolshed.com/ - tools, scripts, and utilities for running IIS
http://www.tryiis.com

 

[Aaron [SQL Server MVP]]

Why are all of your questions URGENT AND IN ALL CAPS???