... because you take that ( oRs.MoveNext ) behind the condition ?
<%
Set oRs=Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT DISTINCT manager FROM tblManager ORDER BY manager"
oRs.Open strSQL
Do while not oRs.EOF
if Request.Form("selmanager") = oRs("manager") then 'if this is the selected one then display as selected
Response.Write "<OPTION VALUE = '" & oRS ("manager") & "' SELECTED>"
Response.Write oRs("manager") & "</Option>"
else
Response.Write "<OPTION VALUE = '" & oRs ("manager") & "'>"
Response.Write oRs("manager") & "</Option>"
end if
oRs.MoveNext
loop
%>
Steweb
I donât Speak English very well, excuse me !
www.steweb.net