Steve now my output is off. How do I handle that? (I wish I could attach images to my posts)
>Your task shouldn't be to handle values that were not returned from the >query. You need to think of a way to make sure they are returned. You >should be able to accomplish that by using case statements in your query. >Syntax may vary depending on your database, but should be something like >this (assume you db field is called "response"): > >Sum(case response = 'agree' then 1 else 0 end) as agree, >Sum(case response = 'disagree' then 1 else 0 end) as disagree, >Sum(case response = 'strongly agree' then 1 else 0) as strongly_agree > >And so on for each possible value. Your resultset will then contain a total >for each possible value, and a 0 if a value wasn't found at all. > > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:359826 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm