sql="select distinct name from table"
rs.open sql,conn,1,3
do while not rs.eof
set rs1=server.createobject("adodb.recordset")
sql="select sum(sorce) as a from table where stu_id=" & rs("stu_id")
rs1.open sql,conn,1,3
response.write rs1("a") & "<br>"
rs1.close
rs.movenext
loop
rs.close
举例说明,假设
sql=select sum(score) as totalnum,stuname,sex[,...fieldname] where stuid="&stuid
set rs=conn.execute(sql)
if rs.eof and rs.bof then
else
response.write trim(rs("totalnum"))&" "&rs("sex")...
end if
举例说明,假设
sql=select select sum(score) as totalnum,stuname,sex[,...fieldname] where stuid="&stuid
set rs=conn.execute(sql)
if rs.eof and rs.bof then
else
response.write trim(rs("totalnum"))&" "&rs("sex")...
end if