下拉菜单取值问题(菜鸟级)
<%
dim AgentCommission
AgentCommission = 0
set rs = GetRecordset("select * from LFT_AgentCommission WHERE CorpID = " & GetCorpID() & " order by ID Asc")
%>
<select name="Grade">
<%if not rs.Eof then
while not rs.Eof
%>
<option value="<%=rs("Gradename")%>"> <%=rs("Gradename")%> </option>
<%
if AgentCommission = 0 then
AgentCommission = rs("Commision")
end if
rs.movenext
wend%>
<%end if%>
</select>
要求是就在选取不同的<%=rs("Gradename")%> 时候能够取出数据库里和Gradename相对应的Commision值。
Commision 和 Gradename都在LFT_AgentCommission表里