汗你没打开记录集啊?sql="select UserName from cadre_info,exam_score where exam_score.subject='"& subject &"' and cadre_info.UserID=exam_score.userid"set rs1=server.createobject("adodb.recordset") rs1.open sql,conn,1,1
