I have a table showing a persons skill in any particular application. So there are 4 columns of skills - Access, CF, HTML, SQL and numerous rows of people names and a check if they have that skill.
This is then output to a webpage showing the same checkboxes.
I want to show a count of the number of people who have that skill at the bottom of the column.
I can do this for each skill:
Expand|Select|Wrap|Line Numbers
- <cfquery datasource="taskbook" name="GetGMC" maxrows="1">
- select count(GeoMedia) as GeoMediaCount
- from tblSkillBase
- group by GeoMedia
- </cfquery>
Is there any way to write just one query, that counts the number of checks in a column, and produces a sum for each one?
I'm using ancient Coldfusion MX by the way!
Thanks
Neil