I have a problem creating a menu page. What happens is the user selects a reports and from a table the report is generated. Each field that makes the report can contain a list, and the list has to be generated from SQL. The first part works fine, getting the lists and assigning them different cfquery names. I need a cfif to see if the field required a select box, but when I do the cfif I get errors with an extraneous cfif tag. I do the cfset's so they work with any cfoutput.
How do I do this??
<cfif Format is "Distinct"><cfset GDF=#FieldName#></cfoutput>
<cfoutput query="GetDistinct#GDF#"><SELECT NAME="#GDF#">
<option value="#Field#" >#Field#</option>