DaniWeb Forum Index > Web Development > ASP

retain selected value in a dropdown list

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2005

Posts: 52

Reputation: spidey is an unknown quantity at this point

Solved Threads: 0

spidey

Offline

Junior Poster in Training

retain selected value in a dropdown list

Jan 20th, 2008

Hello,

I have a dropdown list (single row only) of languages. If I select 'English", the page will reload, it will pass a variable of the Language ID, and all records in English will display in the table.
How can I retain the value selected in the dropdown? I want the selected language to be selected (displayed) in the dropdown list, not the first nor last.
Thanks in advance!

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<select name="LanguageID" onchange="myForm.submit();">
<%do while not rs.eof%>
<option value="<%=rs("LanguageID")%>"><%=rs("Language")%></option>
<%rs.movenext
loop%>		
</select>
<select name="LanguageID" onchange="myForm.submit();">
<%do while not rs.eof%>
<option value="<%=rs("LanguageID")%>"><%=rs("Language")%></option>
<%rs.movenext
loop%>		
</select>

•

Join Date: Sep 2007

Posts: 1,080

Reputation: SheSaidImaPregy is an unknown quantity at this point

Solved Threads: 68

SheSaidImaPregy SheSaidImaPregy is offline

Offline

Veteran Poster

Re: retain selected value in a dropdown list

Jan 21st, 2008

well you can always do it via querystring or session's. just set the querystring or session to the language ID. then do this:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<select name="LanguageID" onchange="myForm.submit();">
<%do while not rs.eof%>
<option value="<%=rs("LanguageID")%>" <% if Trim(Request.QueryString("languageid")) = rs("LanguageID") then %>selected<% end if %>><%=rs("Language")%></option>
<%rs.movenext
loop%>		
</select>
<select name="LanguageID" onchange="myForm.submit();">
<%do while not rs.eof%>
<option value="<%=rs("LanguageID")%>" <% if Trim(Request.QueryString("languageid")) = rs("LanguageID") then %>selected<% end if %>><%=rs("Language")%></option>
<%rs.movenext
loop%>		
</select>

or session object:

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<select name="LanguageID" onchange="myForm.submit();">
<%do while not rs.eof%>
<option value="<%=rs("LanguageID")%>" <% if Session("languageid") = rs("LanguageID") then %>selected<% end if %>><%=rs("Language")%></option>
<%rs.movenext
loop%>		
</select>
<select name="LanguageID" onchange="myForm.submit();">
<%do while not rs.eof%>
<option value="<%=rs("LanguageID")%>" <% if Session("languageid") = rs("LanguageID") then %>selected<% end if %>><%=rs("Language")%></option>
<%rs.movenext
loop%>		
</select>