Not quite. The value returned in a COUNT of the number of each response (sorry I should have said that earlier.
So, it no one answered "disagree" it is not returned, but in the loop I want it represented as 0. >If I understand correctly > >Select response1 from [table] > >The resulting Query can equal 'response1' == 'Agree' or 'Disagree' or >'Neither Agree nor Disagree' or 'Strongly Agree' or 'Strongly Disagree' > >Then you loop over the results from the query and (I am guessing here) you >want to place an 'X' in the box under the correct header? > >Simplest I can think of would be > ><cfoutput query="[qname]"> > <tr> > <cfswitch expression="#[qname].response1#"> > <cfcase value="Agree"> > <td>X</td><td></td><td></td><td></td><td></td> > </cfcase> > <cfcase value="Disagree"> > <td></td><td>X</td><td></td><td></td><td></td> > </cfcase> > <cfcase value="Neither Agree nor Disagree"> > <td></td><td></td><td>X</td><td></td><td></td> > </cfcase> > <cfcase value="Strongly Agree"> > <td></td><td></td><td></td><td>X</td><td></td> > </cfcase> > <cfcase value="Strongly Disagree"> > <td></td><td></td><td></td><td></td><td>X</td> > </cfcase> > </cfswitch> > </tr> ></cfoutput> > > >---------------------------------- >William Seiter > >I am hoping I can explain this correctly. > >I have a table which houses responses to a survey. > >The columns can have any of the following values: > >Agree,Disagree,Neither Agree nor Disagree,Strongly Agree,Strongly Disagree > >I have a table with the headers equal to all of the values above. > >I have a 2nd row that loops through the query and adds a cell in the row for >each value: > >EX: <td>#query.value#</td> > >Here is my problem: > >There are times when not all of the values exists, so I don't have enough of >the dynamic cells in the row. EX: I have a header called "Agree" but the >value "agree" is not returned from the query so it messes up the row. > >My question is how can I create a "fake" column from the query OR create an >empty cell in the row if a value doesn't exist? > >NOTE: The values don't exist so I can "test for existence" if that makes >sense. > >Thanks in advance. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:359805 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm