Listbox, CFOUTPUT, and CFLOOP

[sage703]

I'm trying to create a form to update a record. This record is already saved in
the DB of course, so all the fields already have values. I'm able to have most
of my listboxes show the value that is currently saved for a record as the
default. However, I'm unsure how to make a listbox that uses a <cfloop> to loop
through a list variable to populate the listbox show the value that is saved
for that record. Here's the code:

<select name="Location_State">
<cfoutput>
<option value=""></option>
<cfloop list="#states#" index="i">
<option value="#i#">#i#</option>
</cfloop>
</cfoutput>

For example, if a record has CA saved as the state in question, I want that
value to show up in the listbox as the currently selected value when you go to
update the record. The way it is now (see the above code) the blank option is
the default.

Anyone familiar with coldfusion forms?

Thanks,
S./

[mxstu]

...

<cfset savedState = "IL">
<select name="Location_State">
<cfoutput>
<option value=""></option>
<cfloop list="#states#" index="i">
<option value="#i#" <cfif i eq savedState>selected</cfif>>#i#</option>
</cfloop>
</cfoutput>
</select>

[sage703]

Thanks mxstu,

I actually found another way to do it right after I posted the thread:

<select name="Location_State">
<cfoutput>
<option value=""></option>
<cfloop list="#states#" index="i">
<option value="#i#" <cfif programs.Location_State IS
i>SELECTED</cfif>>#i#</option>
</cfloop>
</cfoutput>
</select>

[mxstu]

Glad you found your solution. Yes, in CF the IS is synonymous with EQ so the statement "... somevalue IS i" is the same as saying "somevalue EQ i".