sqlÇóºÍ´æ´¢¹ý³Ì¸ÃÔõôд

set rs1=server.createobject("adodb.recordset")
sql1="select * from Task where ID='"&request("ID")&"'"
rs1.open sql1,conn,1,1
Notice=rs1("Notice")
Demand=rs1("Demand")
IsPay=rs1("IsPay")
rs1.close:set rs1=nothing

set piaoshu=server.createobject("adodb.recordset")
piaoshu.open "select * from idlist where TaskName='"&request("ID")&"'",conn,1,1
aaaapiaoshu=0
do while not piaoshu.eof
aaaapiaoshu=aaaapiaoshu+piaoshu("Success")
piaoshu.movenext
loop
piaoshu.close:set piaoshu=nothing


set rs=server.createobject("adodb.recordset")
sql="select * from Idlist where TaskName='"&request("ID")&"' and IdName = '"&request("IdName")&"'"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
Success=0
else
Success=rs("Success")
end if


----------------------
µÚÒ»¸öÊǼòµ¥±àºÅ²éѯ


µÚ¶þ¸öÊÇÇóºÍ£¬Êý¾ÝÁ¿±È½Ï´ó  Success×Ö¶Î(INT)


µÚÈý¸öÒ²ÊDZàºÅºÍÒѳɹ¦²éѯ

---

µÚ¶þ¸ö£º

piaoshu.open "select sum(success)as success from idlist where TaskName='"&request("ID")&