谢谢版主,不过具体的代码我还是不明白怎么写,请指教:
你看一下我那里写错了:
<select name="jgdw" size="1" onChange=window.location.href="tianjia.asp">
<option value="">请选择</option>
<%set rs = server.CreateObject ("Adodb.recordset")
sql = "select * from [jgdw] order by jgdwname"
rs.open sql,conn,1,1
if rs.eof and rs.bof then
response.write "<option value=>请先添加来源</option>"
else
do while not rs.EOF%>
<option value=<%=rs("jgdwname")%>><%=rs("jgdwname")%></option>
<%rs.MoveNext
loop
end if
rs.Close
set rs=nothing%>
<option value="">添加新值</option>
</select>
谢谢!!!