select语句实现
从上一个select 中取得一个值作为下一个select的条件
报错的语句是:Set rs = conn.Execute("select 客户名称 from partment where 所属部门= "partm"")
代码如下:
<td><select name="partm">
<%
Set rs = conn.Execute("select 所属部门 from partment")
while not rs.eof
Response.Write "<option value='" & rs("所属部门") & "'>" & rs("所属部门") & "</option>"
rs.MoveNext
wend
rs.close
%>
<select></td>
</tr>
<tr>
<td>使用人:</td>
<td><select name="use">
<%
Set rs = conn.Execute("select 客户名称 from partment where 所属部门= "partm"")
while not rs.eof
Response.Write "<option value='" & rs("客户名称") & "'>" & rs("客户名称") & "</option>"
rs.MoveNext
wend
rs.close
%>
<select></td>