asked on

setting a default value for a form field in asp

<%If Not rsCountries.eof then%>
<select class=content name="COUNTRY" tabindex="14" size="1">
<%If Request.form("country") <> "" Then Do While not rsCountries.Eof
If ucase(Request.form("country")) = ucase(rsCountries("COUNTRY_NAME")) Then%>
<option value="<%=rsCountries("COUNTRY_NAME")%>" selected><%=rsCountries("COUNTRY_NAME")%></option>
<%Else%>
<option value="<%=rsCountries("COUNTRY_NAME")%>"><%=rsCountries("COUNTRY_NAME")%></option>
<%End If
rsCountries.MoveNext
Loop
Else
Do While not rsCountries.Eof%>
<option value="<%=rsCountries("COUNTRY_NAME")%>"><%=rsCountries("COUNTRY_NAME")%></option>
<%rsCountries.MoveNextLoop
End If%>
</select>
<%End If%>
</td>
</tr>
<tr>

Please help !

mattfairw

please direct comments here so they are all grouped

https://www.experts-exchange.com/questions/21122318/setting-a-default-value-for-a-form-field-in-asp.html

ASKER CERTIFIED SOLUTION

mlpk_tyr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

agodil

ASKER

hey mlpk_tyr, i tried the code you wrote but i does not work ! i get an internal server error! should i post the whole code so you can take a look at it ??

peh803

Is this still a problem for you? Here's some basic code that should work for setting the value of a select box in ASP (I have taken your code and modified it a bit):

<%
If Not rsCountries.eof then
%>
<select class=content name="COUNTRY" tabindex="14" size="1">
<%
Do While not rsCountries.Eof
If ucase(Request.form("country")) = ucase(rsCountries("COUNTRY_NAME")) Then
sSelected = " selected"
else
sSelected = ""
end if
%>
<option value="<%=rsCountries("COUNTRY_NAME")%>" <%=sSelected%>>
<%=rsCountries("COUNTRY_NAME")%>
</option>
<%
rsCountries.MoveNext
Loop
%>
</select>
<%End If%>
</td>
</tr>

Let me know if this works for you, or if you have any questions.

Regards,
peh803