由代码实现以下sql语句:

Set rs= Server.CreateObject("ADODB.Recordset")
    sql="select zuzhi.kaishiw,zuzhi.jieshuw,zuzhi.jibie from zuzhi,guanli where guanli.zhanghao='"& zh &"' and zuzhi.jibie<guanli.jibie "
    rs.open sql,conn,1,1
 ts=rs.RecordCount

    for i=1 to ts
  
  pp=pipei(zh,cint(rs(0)),cint(rs(1)),"0")
  sq(i)="select shuxingkz.mingcheng,shuxingkz.biaoqian,shuxingkz.daima from shuxingkz  where shuxingkz.guanlizh='" & pp & "'"

将来得帐号用一定匹配规则匹配后再到数据库取属性值从而得到一sql语句数组

我想用两重叔祖实现得到结果收集

最终高高手说:: 用一个公用变量实现多循环sql结果的收集!!

dim zh
 dim ts
 dim k
 zh=request("zhanghao")

 dim sq(100)
 dim biao(1000)
 dim ming(1000)
 dim dai(1000)

 
 Set rs= Server.CreateObject("ADODB.Recordset")
    sql="select zuzhi.kaishiw,zuzhi.jieshuw,zuzhi.jibie from zuzhi,guanli where guanli.zhanghao='"& zh &"' and zuzhi.jibie<guanli.jibie "
    rs.open sql,conn,1,1
 ts=rs.RecordCount

    for i=1 to ts
  
  pp=pipei(zh,cint(rs(0)),cint(rs(1)),"0")
  sq(i)="select shuxingkz.mingcheng,shuxingkz.biaoqian,shuxingkz.daima from shuxingkz  where shuxingkz.guanlizh='" & pp & "'"
  'response.write "sql= " & sq(i)& "<BR>" 
    rs.movenext
   next
response.write ts 
      k=1
 for i=1 to ts
  Set rs= Server.CreateObject("ADODB.Recordset")
     rs.open sq(i),conn,1,1
  for j=1 to rs.RecordCount
   ming(k)=rs(0)
   biao(k)=rs(1)
   dai(k)=rs(2)
    rs.movenext
   response.write "k=" & k & "<BR>"
   k=cint(k)+1
    
    next   //这个在两循环中不断加1的k值起到了关键作用!!!
 next
 
 for i=1 to k    //读取时只要从1到k循环就o了    高高手就是高高手``````
  'response.write ming(i) & "<BR>"
 next

发表于 @ 2007年03月30日 22:11:00|评论(loading...)|编辑