Sorry let me try that again...what I meant was....
Not quite. The value returned is a COUNT of the number of each response (sorry I should have said that earlier. So, if 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:359807 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
