I'm using sql2000. Thanks for getting me started-looks like I can go from
here.
j
-----Original Message-----
From: Deanna Schneider [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 10:26 AM
To: CF-Talk
Subject: Re: adding counts
If you're using oracle, you could so something like this:
SELECT SUM(DECODE(abstype, 'E', 1, 'U', 1, 0)) AS totalabsences
In plain english, this says:
If abstype = 'E' then add 1 to totalabsences,
elseif abstype = 'U' then add 1 to totalabsences,
else add zero to totalabsences
You can add additional lines to it like this one:
SUM(DECODE(abstype, 'T', 1, 0)) AS totaltardies,
SUM(DECODE(abstype, 'E', 1, 0)) AS totalexcused,
SUM(DECODE(abstype, 'U', 1, 0)) AS totalunexcused
FROM yourtable
WHERE yourconditions
If you're using ACCESS, you do this with iif. I can look up the syntax if
you need it. If you're using mssql, I can't help ya.
-d
Deanna Schneider
Interactive Media Developer
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
