Question

ASP 怎么将数据库表中取出的赋值给下拉列表/菜单

还下拉的"列表/菜单" 的值怎么做呢??
我是从数据库中取出的值做成的下拉列表:
<%
Dim strSql,rs
strSql="select BRANCH_NAME from BRANCH "
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSql, my_Conn, adOpenKeyset, adLockOptimistic, adCmdText
if rs.eof and rs.bof then
response.write "No Data"
response.end
end if
response.write strSql
%>
<select name="BranchName" id="BranchName">
<%
do while not rs.eof
response.write "<option>" & rs("BRANCH_NAME") & "</option>" & vbCrLf
rs.movenext
loop
%>
</select>
<%
rs.close
set rs=Nothing
set strSql=Nothing
%>

Answer 1

response.write "<option>" & rs("BRANCH_NAME") & "</option>" & vbCrLf
改成
response.write "<option value=""" & rs("BRANCH_NAME") & """>" & rs("BRANCH_NAME") & "</option>" & vbCrLf
就是给option加上一个value属性，它的值就是你要赋给下拉列表的值