why do you need the 2nd loop rather than simply outputting the value of the query column from the main loop?
On Thu, Dec 11, 2014 at 12:02 AM, Torrent Girl <[email protected]> wrote: > > 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:359803 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
