default value in a combo

[sgueper]

Sorry my english.

I don't know how to select a default value in a list or combobox. Can you help me?

Thanks

 

[Veep]

<SELECT Name="mySelect">
<option Value="One">One</Option>
<option Value="Two" SELECTED>Two</option>
<option value="Three">Three</option>
</SELECT>

"Two" will be the default. Hope that's what you meant.

 

[sgueper]

Thanks a lot for your help, but the options are a recordset.

It is like this:

<option value="<%=RS2("Id")%>"><%=RS2("Activity")%></option>

and i don't know how to select one of them.

Thanks,
Silvia

 

[DreXor]

<select name="whatever">
<%
Defaultvalue = whateveryouneedittobe
do while not RS2.EOF
If RS2("ID ? ACTIVITY") = DefaultValue Then
optSel = " SELECTED"
Else
optSel = ""
End If
%>
<option value="<%=RS2("Id")%>"<%=optSel%>><%=RS2("Activity")%></option>
<%
RS2.MoveNext
Loop
%>
</select>

 

[Veep]

Are you pulling the previously selected (saved) "ID" from the database before you populate the select?

<%
set conn=server.createobject("ADODB.CONNECTION")
conn.open yourConnectionString
strSql="SELECT * FROM myTABLE WHERE myCriteria=" & myCriteria
set rs=conn.execute(strSql)
If not rs.eof then
   'more variable assignments here
   mySelectID = rs("mySelectIDField")
End if
rs.close
set rs=nothing

' later on ...you build your SELECT from another recordset
' I'm leaving that stuff out
%>
<SELECT name="mySelect">
<%
do while not rs.eof
%>
<option value="<%=RS2("Id")%>" <%IF RS2("ID") = mySelectID THEN%>SELECTED<%End if%>><%=RS2("Activity")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
%>
</SELECT>

Hope this helps.

 

[MikeCallon]

In order to be xhtml compliant you'll need to do a

Response.Write("selected=""selected""")

instead of just "SELECTED"

Mike

 

[sgueper]

Thank you very much. It is fantastic. today is hapier now.

Good day everybody.

Silvia