|
|
| Counting Records [+] Favor-It | |
| |
 |
| | Sort By:
|
I have seen many requests in forums and messageboards for counting records and displaying the total. Well, this little wizard will help you accomplish this task. Fill in the form below and it will crank out the code for you. Author: Derek Truman Code: ASP 3.0 & VBScript |
We can count records in a table with these a few lines of codes. First we must send an SQL statement to database engine. Count of records will be first value of resultset. Author: Dotnetindex.com Code: ASP 3.0 & VBScript |
This tutorial by Charles Carroll shows how to count records in a recordset without getting the dreaded -1. Author: Charles M. Carroll Code: ASP 2.0 & VBScript |
| | |
This article, written by Phil Paxton, describes how not to count
records in a recordset and why. Author: Phil Paxton Code: ASP 2.0 & VBScript |
Sometimes we worry about limits of database table and we need to know how manay recods we have. In ASP we could count all recods using a loop. But if we have a small piece of knowledge about SQL script, our script works better and faster. Author: Dotnetindex.com Code: ASP 3.0 & VBScript |
Many ASP beginners complain the ADO recordcount attribute. Someone even thought that database didn't support this attribute. Because it always returns -1 other than the number of records.
Author: Ray Gao Code: ASP 3.0 & VBScript |
It was coded to count all records in an access database but also in the open string you will notice that we define Threads=200;, this will enable the database to allow 200 people to connect without slowing down the database. Code: ASP 3.0 & VBScript |
| | |
Are you tired of always getting "-1" returned when you ask your Recordset how many records it contains? ASP 101 thought you might be, and has written an article that describes a workaround. Author: Gary Williams Code: ASP 2.0 & VBScript |
This script counts the records in a database. Many people who attempt to use the .recordcount property have the value -1 returned to them. In a nutshell, -1 means "I don't know how many records this query/table contains". Author: Juan Llibre, Charles Carroll Code: ASP 3.0 & VBScript |
Icon Key >
 - Recently Updated
 - Showcase Listing
|