Skip to main content
Known Participant
December 3, 2008
Question

cfoutput problem

  • December 3, 2008
  • 1 reply
  • 334 views
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 ?
    This topic has been closed for replies.

    1 reply

    Inspiring
    December 3, 2008
    Hi,

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