Since youre handling all of the the counts in the case statements, you dont need to select the increasedKnowlege column value, order or group by it anymore. Your SQL should be:
SELECT Sum(case increasedKnowledge WHEN 'agree' then 1 else 0 end) as 'agree', Sum(case increasedKnowledge WHEN 'disagree' then 1 else 0 end) as 'disagree', Sum(case increasedKnowledge WHEN 'Neither Agree nor Disagree' then 1 else 0 end) as 'Neither Agree nor Disagree', Sum(case increasedKnowledge WHEN 'strongly agree' then 1 else 0 end) as 'strongly agree', Sum(case increasedKnowledge WHEN 'Strongly Disagree' then 1 else 0 end) as 'Strongly Disagree' FROM evaluationReponsesCourse13 On Dec 11, 2014, at 10:54 AM, Torrent Girl <[email protected]> wrote: > > Good idea. > > I saved an image here: > > http://4.bp.blogspot.com/-dGtVwwkzAvc/VIm9VwuYORI/AAAAAAAADy0/PDbajG1LnEU/s1600/output.png > > So what I need to do is get the values in the appropriate cells on the table. > > When I loop or output with a query, I get too many cells. > > >> there are many browser plugins where you can take screenshots and post >> online and send a link. Why not use one of those ? >> >> >> On Thu, Dec 11, 2014 at 3:13 PM, Torrent Girl <[email protected]> wrote: >> >>> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:359830 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
