Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Basics For beginner programmers starting with "classic" ASP 3, pre-".NET." NOT for ASP.NET 1.0, 1.1, or 2.0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 24th, 2003, 10:14 AM
Registered User
 
Join Date: Jul 2003
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default how to find total no. of records

I have fields "Singer","Song" in a Table "Album"

Now i want to run a combination of SQL Query & other functions combined so that i finally get hold of the total no. of songs sung by each different Singer existing in the "singer" field

i tried using RecordCount propert of Recordset but it dint work out.

how do i do this.

 
Old July 24th, 2003, 08:04 PM
Friend of Wrox
Points: 2,376, Level: 20
Points: 2,376, Level: 20 Points: 2,376, Level: 20 Points: 2,376, Level: 20
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: , , Australia.
Posts: 596
Thanks: 1
Thanked 3 Times in 3 Posts
Default

To get a list of the singers and the number of records for each singer (ie the number of songs) use:

select Singer, count(Singer) from Album group by Singer.

This assumes that there is only one record for each singer and song combination.

Rod

======================================
They say, best men are moulded out of faults,
And, for the most, become much more the better
For being a little bad.
======================================




Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP Total Records Fetched cancer10 Classic ASP Databases 3 October 20th, 2006 12:21 PM
Get total records europhreak Classic ASP Basics 10 February 5th, 2006 02:12 PM
Find total row count when databinding guppyheart BOOK: ASP.NET Website Programming Problem-Design-Solution 0 September 17th, 2003 07:40 PM
finding total no. of records reshmisworld Classic ASP Databases 4 July 24th, 2003 06:35 PM
finding total no. of records reshmisworld Classic ASP Databases 1 July 24th, 2003 03:23 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.