To count the number of records in a table. At the same time you can use the same recordset for other work also.
Set Rs=Server.CreateObject("ADODB.Recordset")
Rs.CursorLocation=3 ' this line is must for Record Count
sql=".........."
Rs.Open sql,Con
cnt=Rs.RecordCount
Contents
- AddEditDelete-Advanced
- AJAX - How to say Hello
- Common Functions
- CONVERT DD-MM-YYYY TO MM/DD/YYYY
- Convert dd/mm/yyyy to mm/dd/yyyy
- CONVERT ID TO NAME
- Convert mm/dd/yyyy to dd/mm/yyyy format in classic asp
- displaying timetable
- First Record Skipped by ASP.NET
- Free Photo Web sites
- get data from excel using asp
- How to convert mm/dd/yyyy to dd-mmm-yy in classic asp
- How to convert mmddyyyy into ddmmyyyy in classic asp
- Javascript : Country-State DropDown
- ORACLE SQL CASE-END
- Oracle Table to Insert Statements
- Random Number in Classic ASP
- Rs.RecordCount
- Select Box Template