sql_GetThirdOrganization = "select * from ThirdOrganization order by id desc"
set rs_GetThirdOrganization = server.CreateObject("adodb.recordset") rs_GetThirdOrganization.Open sql_GetThirdOrganization,objconn,1,1
%>
var temp,temp_2;//////////////javascript块
temp=0;///////////////////for循环变量初始化
Related = new Array();//////////////////////数组,用来存放三级组织的id,名称,和对应的父ID
<%
temp_2 = 0 ‘一个临时变量,用来存放三级组织的个数
while not rs_GetThirdOrganization.eof ‘循环第三级组织
%>
////////////三维分别对应的第三级组织的ID,第三级组织的名称
////////////第三级别组织的父ID(即第二级别ID)
Related[<%=temp_2%>] = new Array("<%=rs_GetThirdOrganization(“id”)%>","<%=rs_GetThirdOrganization(“OrganizationName”)%>","<%=rs_GetThirdOrganization(“parentID”)%>");
Set objRs = Server.CreateObject("ADODB.Recordset")
Set objSubRs = Server.CreateObject("ADODB.Recordset")
strSql1= "SELECT fieldA,fieldB FROM tabble1"
objRs.Open strSql1,objConn ,adOpenStatic
Do While Not objRs.Eof
strSql2 = "SELECT * FROM table2 WHERE table2.fieldA ='"&objRs("fieldA")&"'"
objRs.Open strSql2,objConn ,adOpenStatic
楼主,我来说两句:
其实你要的就是嵌套查询,比如:
select * from [select * from tbl_user]. a
其实这句SQL是没有任何实际意义的,我们不会真的这么写,但是结构都是一样的
就是用“[]”把SQL括起来,后面加上“.”和一个别名,如a。就可以了
还可以几个表一起查,如:
select * from tbl_aaa a,[select * from tbl_bbb]. b where a.no=b.no