Using CFselect

[ahksar]

I have a question in dynamically populating select boxes. How can I highlight the value that is already in the database, for instance, if I am pulling out the list of countries, and the country in the database is US, how can the selected value in the select box be set to US?How can i make it show up instead of nothing, or a default value being selected.

Thanks
ahksar

 

[Silvano]

<select name=&quot;selectCountry&quot;>
<cfoutput query=&quot;countries&quot;>

<option <cfif usaStates EQ &quot;Colorado&quot;>selected</cfif>>#usaStates#</option>

</cfoutput>
</select>


Sylvano
dsylvano@hotmail.com

 

[ahksar]

Thanks a lot.....saved me a lot of headache