|
|
| Counting Records [+] Favor-It | |
| |
 |
| | Sort By:
|
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 |
You may use RecordCount object found in OleDB. But scope of this code is to count records in a table using an SQL command. Sql command is "select count(*) as total from DATATABLE" Author: DevTutorials.info Code: ASP 3.0 & VBScript |
Icon Key >
 - Recently Updated
 - Showcase Listing
|