can you show us the actualy query, as a query shouldn't return nothing, it should return 0 if the count is 0 The only instance where you should get nothing is if there are no rows of data returned
On Thu, Dec 11, 2014 at 12:23 AM, Torrent Girl <[email protected]> wrote: > > 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:359812 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
