28,390
社区成员
发帖
与我相关
我的任务
分享
<%
classid = trim(request("classid"))
'数据库连接字段已经做好conn
%>
<tr>
<td width='25%'><p align='right'><b>· 父类名称</b></td>
<td width='75%'><p align='left'>
<select name="classid">
<%
set rs1=server.CreateObject("adodb.recordset")
rs1.open "Select * From class",conn,1,1 'class为父类表
if rs1.bof and rs1.bof then
response.write "<option>父类尚无数据,请先添加</option>"
else
do while not rs1.eof
if rs1("classid")=classid then
response.write "<option value='"& rs1("classid") & "' selected>" & rs1("classname") & "</option>"
else
response.write "<option value='"& rs1("classid") & "'>" & rs1("classname") & "</option>"
end if
rs1.movenext
loop
end if
call rs1close()
%>
</select></td>
</tr>