It's pretty much as you said, except the syntax is: SUM(CASE WHEN logclass_id = 1 THEN 1 ELSE 0 END) as sent
On 5/1/07, Robert Rawlins - Think Blue wrote: > Ok, > > > COUNT(WHERE LogClass_ID = 1) AS Sent > COUNT(WHERE LogClass_ID = 2) AS Failed > COUNT(WHERE LogClass_ID = 3) AS Postponed > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create Web Applications With ColdFusion MX7 & Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276615 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4