DOH!! end of the day, yeah... cc.cc_type_id isn't part of a group by or aggregate function..
and I need those end values as part of the returned record set On 12/13/2012 4:49 PM, John M Bliss wrote: > This gives you the error...? > > CASE > WHEN cc.cc_type_ID = 1 THEN @careCB + 1 > WHEN cc.cc_type_ID = 2 THEN @careFBC + 1 > WHEN cc.cc_type_ID = 3 THEN @careSBC + 1 > WHEN cc.cc_type_ID = 4 THEN @careVACC + 1 > WHEN cc.cc_type_ID = 5 THEN @careOFCC + 1 > ELSE 0 > END AS myvar > > On Thu, Dec 13, 2012 at 3:45 PM, Scott Stewart > <webmas...@sstwebworks.com>wrote: > >> CASE >> >> WHEN cc.cc_type_ID = 1 THEN @careCB + 1 >> >> WHEN cc.cc_type_ID = 2 THEN @careFBC + 1 >> >> WHEN cc.cc_type_ID = 3 THEN @careSBC + 1 >> >> WHEN cc.cc_type_ID = 4 THEN @careVACC + 1 >> >> WHEN cc.cc_type_ID = 5 THEN @careOFCC + 1 >> >> ELSE 0 >> >> END >> > > -- Scott Stewart Adobe Certified Expert / Instructor ColdFusion 8, 9 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:353455 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
