请助ASP编程高手-

来源:百度知道 编辑:UC知道 时间:2024/07/04 02:04:27
下面这段代码,我不知道那写错了,数据可以写到数据库,但我再次打开是,显示不了我选者的对象
<select size="1" name="djurl">
<% set rs2=server.CreateObject("ADODB.RecordSet")
sql="select * from djurl where id="&rs("djurl")&""
rs2.open sql,conn,1,1
if rs2.eof and rs2.bof then
response.write "<option selected value=>尚未添加!</option>"
else
%>
<option selected value="<%=rs2("id")%>"><%=rs2("name")%></option>
<%
end if
rs2=close
set rs3=server.CreateObject("ADODB.RecordSet")
sql="select * from djurl"
rs3.open sql,conn,1,1
if NOT rs3.EOF then
do while NOT rs3.EOF
%>
<option value="<%=rs3("id")%>"><%=rs3("name")%></option>
<%
rs3.MoveNext
loop
end if
rs3=close
%>
</s

是要在select里,显示选择已选择的"NAME",再在下拉里显示全部"NAME"吗?

<%
response.write "<select size=""1"" name=""djurl""> "
set rs2=server.CreateObject("ADODB.RecordSet")
sql="select * from djurl"
rs2.open sql,conn,2,3
if rs2.eof and rs2.bof then
response.write "<option selected value=>尚未添加!</option>"
else
do while NOT rs2.EOF
if rs2("id")=rs("djurl") then
response.write "<option selected value="&rs2("id")&" selected>"&rs2("name")&"</option>"
else
response.write "<option selected value="&rs2("id")&">"&rs2("name")&"</option>"
end if
rs2.MoveNext
loop
end if
response.write "</select>"
rs2=close
%>