各位ASP的兄弟你们好,小弟刚学不久,有个问题想请教!如下表所示,这两个字段的值分别在两个表中,每个表的数据量为1000个,这两个字段的值在各表中以ID字段相对应,怎么做才能把他们一一查询出来?

Set conn = Server.CreateObject("ADODB.Connection")ConnStr = "Provider = Sqloledb; User ID = sa; Password = ijL; Initial Catalog = fingerdb; Data Source = (local);" Conn.Open ConnStr '########打开数据库 Set Rs1=server.createobject("adodb.recordset") Set Rs2=server.createobject("adodb.recordset") set Rs1.activeconnection =conn set Rs2.activeconnection =conn sql1="select * from gzb" sql2="seledt * from ryxxb" Rs1.Open sql1, Conn,1,3 Rs2.Open sql2,Conn,1,3 设两个RS是不允许的,不知该怎么做,希望看到的朋友能帮忙解答一下

<% Set conn = Server.CreateObject("ADODB.Connection") ConnStr = "Provider = Sqloledb; User ID = sa; Password = ijL; Initial Catalog = fingerdb; Data Source = (local);" Conn.Open ConnStr '########打开数据库 Set Rs=server.createobject("adodb.recordset") Set Rs1=server.createobject("adodb.recordset")

'set Rs.activeconnection =conn If Conn.State = 1 Then Response.Write("数据库已打开") eLSE Response.Write("数据库没打开") End IF

%> <table border="1" width="986" id="table1"> <tr> <td width="233">工资表SBH</td> <td width="271">工资表姓名</td> <td width="230">ryxxbSBH</td> <td width="229">RYXXB姓名</td> </tr> <% sql1="SELECT 姓名 from gzb" Rs.Open sql1, Conn,1,1 'sql2="select sbh from ryxxb " 'Rs1.Open sql2, Conn,1,1 i=0 do while i<4 %>

<tr> <td width="233"> <%=rs("姓名")%> </td> <% yyy=rs("姓名") sql2="select * from ryxxb where xm='"&yyy&"'" rs1.open sql2 %> <td width="271"> </td> <td width="230"> </td> <td width="229"> </td> </tr> <% i=i+1

Rs.movenext Loop %>

</table> 红色部分总是提示已经打开或关闭

[此贴子已经被作者于2005-8-30 14:59:42编辑过]