请问ASP读取多行数据怎么引用

2012-05-29

请教ASP读取多行数据如何引用在表bb中的字段:Flagtype``````FlagName2```````````aa2```````````bb3``````

请教ASP读取多行数据如何引用
在表bb中的字段:
Flagtype `````` FlagName
2 ``````````` aa
2 ``````````` bb
3 ``````````` cc
3 ``````````` dd
3 ``````````` ee

ASP代码:

C# code

sql = "select FlagName from bb where FlagType=3"rs.open sql,conn,1while not rs.eofN_FlagID=rs("FlagName")rs.movenextwend

想在下拉菜单中引用:

HTML code

<select name=qjtz><option><%=N_FlagID%></option></select>

请教一下SQL及ASP的详细写法,以上写法只能显示一行

[解决办法]

VBScript code

    response.write("<select>")    sql = "select FlagName from bb where FlagType=3"    rs.open sql,conn,1    while not rs.eof        response.write("<option>"&rs("FlagName")&"</option>")    rs.movenext    wend    response.write("</select>")
[解决办法]

VBScript code<select name=qjtz><%sql = "select FlagName from bb where FlagType=3"rs.open sql,conn,1while not rs.eof%><option><%=rs("FlagName")%></option><%rs.movenextwend%>