Heh, you answered your own question.
count()
*** Psycically trying to probe your table/field names)***
SELECT c.class_id, c.class_name, count(r.lname)
FROM class c, registrant r
WHERE c.class_id = r.class_id
GROUP BY c.class_id, c.class_name
-----Original Message-----
From: David Clay [mailto:[EMAIL PROTECTED]]
Sent: May 23, 2001 05:48
To: CF-Talk
Subject: Counting
Can someone help.
Customers are signing up for classes and I need to know how many (Count) are
in a class at any given time. That number needs to be output on the same
row as the class number. Looking for code on this.
Having a major brain fart. Your help is appreciated. Thank you
Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
