Anyone know how to get this in SQLserver without two queries? I'm outputting
something like: "10 incomplete out of 23 for user Joe Shmoe". I know this is
totally wrong, but maybe someone will get my drift:
<CFQUERY>
SELECT
tIncomplete.count(*) AS incompleteTasks,
tTotal.count(*) AS totalTasks
FROM TASKS AS tIncomplete, TASKS AS tTotal
WHERE
tIncomplete.num_peopleID = 184 AND
tIncomplete.bit_complete = 0 AND
tTotal.num_peopleID = 184
</CFQUERY>
I could just do it in two queries, but I'm really trying to do this project
right this time - hehe.
Adam.
______________________________________________________________________
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
