cfoutput problem

[Olivia_Crazy_Horse]

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 ?

[Daverms]

Hi,

You can't use a <cfoutput query> inside a <cfoutput> tag, Use <cfloop query> instead.