Repeating output with cfif statement

[sviolet]

I have a problem when multiple checkboxes are "turned on' when multiple values
exist for a field in a database. For example:

The following code produces the following output:

<cfif #INSTREAM_TYPE# IS "Stormwater Outfalls">
<input type="checkbox" name="INSTREAM_TYPE" value="Stormwater"
checked>Stormwater Outfalls<br></CFIF>
<cfif #INSTREAM_TYPE# IS NOT "Stormwater Outfalls">
<input type="checkbox" name="INSTREAM_TYPE" value="Stormwater">Stormwater
Outfalls<br>
</cfif>


<cfif #INSTREAM_TYPE# IS "Stormwater Detention">
<input type="checkbox" name="INSTREAM_TYPE" value="WaterDent"
checked>Stormwater Detention<br></cfif>
<cfif #INSTREAM_TYPE# IS NOT "Stormwater Detention">
<input type="checkbox" name="INSTREAM_TYPE" value="WaterDent">Stormwater
Detention<br>
</cfif>


<cfif #INSTREAM_TYPE# IS "Habitat Enhancement and Restoration">
<input type="checkbox" name="INSTREAM_TYPE" value="Habitat" checked>Habitat
Enhancement and Restoration<br></cfif>
<cfif #INSTREAM_TYPE# IS NOT "Habitat Enhancement and Restoration">
<input type="checkbox" name="INSTREAM_TYPE" value="Habitat">Habitat
Enhancement and Restoration<br>
</cfif>



Stormwater Outfalls
*Stormwater Detention
Habitat Enhancement and Restoration

*Stormwater Outfalls
Stormwater Detention
Habitat Enhancement and Restoration

What I want the output to look like:

*Stormwater Outfalls
*Stormwater Detention
Habitat Enhancement and Restoration

Any help you could provide would be greatly appreciated

Thanks

[jorgepino]

this will reduce the amount of code


<input type="checkbox" name="INSTREAM_TYPE" value="Stormwater" <cfif
#INSTREAM_TYPE# IS "Stormwater Outfalls">checked</CFIF>>Stormwater Outfalls<br>
<input type="checkbox" name="INSTREAM_TYPE" value="WaterDent" <cfif
#INSTREAM_TYPE# IS "Stormwater Detention">checked</cfif>>Stormwater
Detention<br>
<input type="checkbox" name="INSTREAM_TYPE" value="Habitat" <cfif
#INSTREAM_TYPE# IS "Habitat Enhancement and Restoration">checked</cfif>>Habitat
Enhancement and Restoration<br>

[CFDEBUG]

Do you have this code within a loop?.

Also you could combine two cfifs into one by doing this

<input type="checkbox" name="INSTREAM_TYPE" value="Stormwater" <cfif
instream_type eq "Stormwater Outfalls">checked</cfif>>Stormwater
Outfalls<br></CFIF>

[sviolet]

Thanks for your help

The following works except for the fact that if a checkbox is not selected -
the checkbox label doesn't show up. How can i make it so a checkbox appears
with a label but is unchecked if the the value doesn't exist? (note: different
variable names in this post)

<input type="checkbox" name="INSTREAM_TYPE" value="Sediment Removal" <cfif
#instream_type# eq "Sediment Removal">checked
<br>Sediment Removal</cfif>

<input type="checkbox" name="INSTREAM_TYPE" value="Vegetation Removal" <cfif
#instream_type# eq "Vegetation Removal">checked
<br>Vegetation Removal</cfif>

<input type="checkbox" name="INSTREAM_TYPE" value="Debris Removal" <cfif
#instream_type# eq "Debris Removal">checked
Debris Removal<br></cfif>

[sviolet]

I should mention, I am not using a cfloop, just cfoutput:

<CFOUTPUT QUERY="EditQuery2">
<input type="checkbox" name="INSTREAM_TYPE" value="Sediment Removal" <cfif
#instream_type# eq "Sediment Removal">checked
<br>Sediment Removal</cfif>

<input type="checkbox" name="INSTREAM_TYPE" value="Vegetation Removal" <cfif
#instream_type# eq "Vegetation Removal">checked
<br>Vegetation Removal</cfif>

<input type="checkbox" name="INSTREAM_TYPE" value="Debris Removal" <cfif
#instream_type# eq "Debris Removal">checked
Debris Removal<br></cfif>

</CFOUTPUT>

[CFDEBUG]

Well, you have same variable names. Anyway you need to put the cfif before the
label like this

<input type="checkbox" name="INSTREAM_TYPE" value="Sediment Removal" <cfif
instream_type eq "Sediment Removal">checked</cfif>>
<br>Sediment Removal.

Since you are using query, ofcourse it will show up multiple times since it
loops thru all rows and displays checkboxes that many times. To remove that, do
this

<cfoutput>
<cfset instr_list = valuelist(EditQuery2.instream_type)>
<input type="checkbox" name="INSTREAM_TYPE" value="Sediment Removal" <cfif
listfindnocase(instr_list,"Sediment Removal")>checked</cfif>
<br>Sediment Removal

Do the other 2 checkboxes similar to above. If this has any issue, you could
use quotedvaluelist() instead of valuelist() since this is a string. But I'm
sure valuelist() itself should work.

[sviolet]

Well, you have same variable names. >>>Sorry my mistake! Anyway you need to
put the cfif before the label like this

<input type="checkbox" name="INSTREAM_TYPE" value="Sediment Removal" <cfif
instream_type eq "Sediment Removal">checked</cfif>>
<br>Sediment Removal.

Since you are using query, ofcourse it will show up multiple times since it
loops thru all rows and displays checkboxes that many times. To remove that, do
this

<cfoutput>
<cfset instr_list = valuelist(EditQuery2.instream_type)>
<input type="checkbox" name="INSTREAM_TYPE" value="Sediment Removal" <cfif
listfindnocase(instr_list,"Sediment Removal")>checked</cfif>
<br>Sediment Removal

>>>>I tried the above and still the checkbox repeats (if there are 3 instream

type values, the checkbox repeats 3 times)
???Thanks of your help