I've got a query that counts how many times a student is absent/tardy. It
outputs fine BUT i need it to do things slightly differently- I need to
combine a couple of the codes to make a total (For example 3 Excused +2
Unexcused= 5 absences). What is the best way to do this?
<CFQUERY NAME="MissedDays" DATASOURCE="dsn">
SELECT T_ABS.QUARTER, T_ABS.ID, Count(T_ABS.ABSType) AS CountOfABSType,
T_ABS.DAYTITLE
FROM T_ABS, T_Quarter
WHERE ((T_ABS.ABSDATE >= T_Quarter.BegQuarter) AND (T_ABS.ABSDATE <=
T_Quarter.EndQuarter))
GROUP BY T_Quarter.QUARTER, T_ABS.ID, T_ABS.DAYTITLE
</CFQUERY>
So how do I get my CountOfABSType to do this?
Thanks in advance.
j
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
