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

Reply via email to