Choosing the selected item for updating <select>

[Newsgroup_User]

I have a form that has multiple <select> form items. I have an update page
that allows the user to edit information. I would like the <select> to
preselect the item that matched the db entry so the user doesn't have to
reselect it each time.

The <select> is populated from a database. How can I do this?

I've done it before using a static <select> options using a <cfif>
statement.

<cfif #GetMyCase.country# EQ #id#>selected="selected"

<select name="country">
<cfoutput query="ListCountry">
<option value="#id#">#country#</option>
</cfoutput>

Thanks.

[Dan_Bracuk]

The easy way is to use <cfselect selected="#what_you_want#">

Slightly harder, but not much is to put your cfif tag inside your option tag. You have all the code, you just have to re-arrange it slightly.

[Newsgroup_User]

The first did not work. I changed the variables in the cfif and it worked.
thanks