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:359802 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
