UC知道asp高手过来！
来源：百度知道 编辑：UC知道 时间：2024/06/17 22:22:22
在网页上有A下拉条跟B下拉条！~！~
但是A与B下拉条是读取不同表内的的东西！如何实现？
<!--#include file="admin.asp"-->
<!--#include file="conn.asp"-->
<%
name=session("name")
Set rs1 = Server.CreateObject("ADODB.Recordset")
sql1="select * from user order by id desc"
sql2="select * from khlx order by aid desc"
rs1.open sql1,conn,1,3
rs1.open sql2,conn,1,3
<select name="khxm" id="khxm">
<option value="客户姓名">选择客户姓名</option>
<%
if not rs1.eof then
i=0
do while not rs1.eof
%>
<option value="<%=rs1("name")%>"><%=rs1("name")%></option>
<%
i=i+1
if i >= MaxPerpage then exit do
rs1.movenext
loop
end if
%>
但是A与B下拉条是读取不同表内的的东西！如何实现？
<!--#include file="admin.asp"-->
<!--#include file="conn.asp"-->
<%
name=session("name")
Set rs1 = Server.CreateObject("ADODB.Recordset")
sql1="select * from user order by id desc"
sql2="select * from khlx order by aid desc"
rs1.open sql1,conn,1,3
rs1.open sql2,conn,1,3
<select name="khxm" id="khxm">
<option value="客户姓名">选择客户姓名</option>
<%
if not rs1.eof then
i=0
do while not rs1.eof
%>
<option value="<%=rs1("name")%>"><%=rs1("name")%></option>
<%
i=i+1
if i >= MaxPerpage then exit do
rs1.movenext
loop
end if
%>
重新定义一个rs2
<%
dim rs2
Set rs2 = Server.CreateObject("ADODB.Recordset")
sql2="select * from khlx order by aid desc"
rs2.open sql2,conn,1,3
%>
<select name="khlx" size="1" id="khlx">
<%
if not rs2.eof then
i=0
do while not rs2.eof
%>
<option value="<%=rs2("glx")%>"><%=rs2("glx")%></option>
<%
i=i+1
if i >= MaxPerpage then exit do
rs2.movenext
loop
end if
%>
</select>
不是SQL库吗？语句写的这么麻烦
提示什么错误啊 说清楚