28,409
社区成员




<select name="u_school">
<%
set rstemp=server.createobject("adodb.recordset")
sqltemp = "select * from mschool "
rstemp.open sqltemp,conn,1,1
if rstemp.eof then
%>
<option value="" selected="selected"></option>
<% else %>
<% do while not rstemp.eof
If rstemp("schoolid") = 修改的RS的schoolid的值 Then
%>
<option value="<%=rstemp("schoolid")%>" selected="selected"><%=rstemp("sname")%></option>
<%else%>
<option value="<%=rstemp("schoolid")%>"><%=rstemp("sname")%></option>
<%end if%>
<% rstemp.movenext %>
<% loop %>
</select>
<% do while not rstemp.eof
If rstemp("schoolid") = 修改的RS的schoolid的值 Then
%>
<option value="<%=rstemp("schoolid")%>" selected="selected"><%=rstemp("sname")%></option>
<%else%>
<option value="<%=rstemp("schoolid")%>"><%=rstemp("sname")%></option>
<%end if%>
<% rstemp.movenext %>
<% loop %>