Count and Display Number of Records ASP Script

Count and Display Number of Records ASP Script - ASP Web Pro

Active Server Pages Programming by ASP Web Pro

ASP Scripts

COUNT AND DISPLAY NUMBER OF RECORDS

There are a lot of times when web designers need to count and display the number of records you have in their database. There are two simple ways to do this, be using DO...LOOP or by using COUNT in your SQL statement. Below are examples of both.

If you want to use the DO...LOOP method, paste the below code into your page:

<%
DIM mySQL, objRS
mySQL = "SELECT * FROM myTable"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL, objConn

' Count how many records exist
DIM iRecordCount
iRecordCount = 0
DO WHILE NOT objRS.EOF
iRecordCount = iRecordCount + 1
objRS.MoveNext
Loop

' Display result
Response.Write "(" & iRecordCount & ")"

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

The SQL COUNT method uses a little less code. If you want to use it, just paste this code into your page:

<%
DIM mySQL, objRS
mySQL = "SELECT Count(*) AS intTotal FROM myTable"
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open recSQL, objConn

' Display result
Response.Write objRS("intTotal")

objRS.Close
Set objRS = Nothing
objConn.Close
Set objConn = Nothing
%>

Either method will work. Like most things in ASP, it is really a matter of preference and what type of project you are working on. Happy counting!

< Back to ASP Scripts

Main Menu
Home
ASP Scripts
ASP Tutorials
JavaScripts
Awards
Contact Us

Email This Page

Other Resources
ASP Web Hosting
Search Engine Submission
Programming Help

Your browser does not support inline frames...However, you can click <a href="http://www.RentACoder.com/RentACoder/misc/LinkToUs/ScrollingBidRequests.asp?blnHideChannelSubscribe=true&blnLaunchLinkInNewWindow=true&blnFullTitle=true&txtFromURL=AId_74675"> here</a> to see the related document.

Other ASP Web Sites

Site Map

Last Updated:
04 February 2012