老大,是这么个问题,刚才我又修改了一下,发现弹出窗口基本正常,而且除排在第一位置的"每次登陆提醒"外,其他的查询有或没有,也都弹出或不弹出窗口,唯一的问题是,如果“每次登陆提醒”查询结果为空,以后的查询即使都有结果,都弹不出窗口,为什么呢?好像当执行“每次登陆提醒”后,查询的结果为空的时候,就不再进行别的处理了。附前面的两个查询的代码:
set rs=Server.CreateObject("adodb.recordset")
sql= "SELECT * FROM alertdata WHERE txzt='需要提醒' and syname='"&session("UserName")&"' and szlx='每次登陆提醒' "
rs.open sql,conn,1,1
if not rs.eof then
response.write "<script language='javascript'>"
response.write "parent.getMsg6();"
response.write "</script>"
if rs.eof and rs.bof then
end if
set rs1=Server.CreateObject("adodb.recordset")
sql1= "SELECT * FROM alertdata WHERE txzt='需要提醒' and syname='"&session("UserName")&"' and szlx='每周定期提醒' "
rs1.open sql1,conn,1,1
if not rs1.eof then
response.write "<script language='javascript'>"
response.write "parent.getMsg2();"
response.write "</script>"
if rs1.eof and rs1.bof then
end if 请指点,谢谢!
set rs=Server.CreateObject("adodb.recordset")
sql= "SELECT * FROM alertdata WHERE txzt='需要提醒' and syname='"&session("UserName")&"' and szlx='每次登陆提醒' "
rs.open sql,conn,1,1
if not rs.eof then
response.write "<script language='javascript'>"
response.write "parent.getMsg6();"
response.write "</script>"
if rs.eof and rs.bof then
end if
set rs1=Server.CreateObject("adodb.recordset")
sql1= "SELECT * FROM alertdata WHERE txzt='需要提醒' and syname='"&session("UserName")&"' and szlx='每周定期提醒' "
rs1.open sql1,conn,1,1
if not rs1.eof then
response.write "<script language='javascript'>"
response.write "parent.getMsg2();"
response.write "</script>"
if rs1.eof and rs1.bof then
end if 请指点,谢谢!