Hi everybody,

I am getting infos from a database to get a drop down list filled. When I submit the form I want to automatically select the selected item but it doesn't select. Heres my code where it doesn't work.

<SELECT onChange="javascript:document.SearchState.submit();" name="ddlSearchCountry">
<% Do While not rsCountries.EOF %>
<OPTION value="<% = rsCountries("CountryID") %>" <% if Request.Form("ddlSearchCountry") = rsCountries("CountryID") then %> selected <% end if %>>
<% = rsCountries("Country") %>
</OPTION>
<% rsCountries.MoveNext
loop
rsCountries.close%>
</SELECT>
I've done this tones of time but this time it just won't work. The Request.Form works because i checked if it gets filled by putting it beside <% = rsCountries("Country") %>.

Thank you in advance,

Andy

Hi everybody,

My Values are numeric. what I did was to convert my Request.Form and recordset values both to Int and then it worked.

<SELECT onChange="javascript:document.SearchState.submit();" name="ddlSearchCountry">
<% Do While not rsCountries.EOF %>
<OPTION value="<% = rsCountries("CountryID") %>" <% if cint(DistributorCountryID) = cint(rsCountries("CountryID")) then%>selected<%end if%>><% = rsCountries("Country") %></OPTION>
<% rsCountries.MoveNext
loop
rsCountries.Close%>
</SELECT>

/Peace2u my friends