Question
cfoutput problem
My query joins many tables so it will output duplicates.
I used <cfoutput group="groupName"> and #qryName.fieldName# to display the output and eliminate the duplicates.
However, I have to display a dyanmic dropdown list and I use <cfoutput query> to do that. But it gives an error, saying cfoutput query cannot be in cfoutput group.
I then tried to use group by in the query and just use <cfoutput> instead of cfoutput group but that still did not work.
All the fields are display only, except for the dropdown. How do I combine the two, using cfoutput to display the output (no duplicates) and the dynamic drop down ?
I used <cfoutput group="groupName"> and #qryName.fieldName# to display the output and eliminate the duplicates.
However, I have to display a dyanmic dropdown list and I use <cfoutput query> to do that. But it gives an error, saying cfoutput query cannot be in cfoutput group.
I then tried to use group by in the query and just use <cfoutput> instead of cfoutput group but that still did not work.
All the fields are display only, except for the dropdown. How do I combine the two, using cfoutput to display the output (no duplicates) and the dynamic drop down ?
