问题描述
首先我说一下功能，用的ASP语言。第一，我需要在If(CDBL(RS("TJZ"))<CDBL(RS("BZZ")))AndCDBL(RS("TJZ"))<>-1TheNCOL="#FF0000"后面调用Windows自带的系统声音，没动作前一直响；第二，再查询返回结果到页面后我点到红色行（即报系统声音行）时结束声音。下面是我的代码：<%@codepage=936%><htmllang="zh"><head><title></title><metahttp-equiv="Content-Type"content="text/html;charset=gb2312"/><styletype="text/css"><!--body,td,th{font-family:宋体;font-size:9pt;color:#000000;}--></style></head></head><%setconn=Server.CreateObject("ADODB.Connection")conn.Open("Provider=MSDAORA.1;Password=APP;UserID=MW_APP;DataSource=PMSTJ2;PersistSecurityInfo=True")SQL="SELECTYTJ.*,S.BZZ,S.BHFROMPMS_MWT_SBD_YX_YTJYTJ,PMS_TJ_YTJ_YJ_SQLSWHERES.JLLX=YTJ.JLLXANDS.FL=YTJ.FLANDS.JLDL=YTJ.LBANDTO_char(TJSJ,'YYYY-MM-DD')=to_char(sysdate,'YYYY-MM-DD')ORDERBYS.BH"setrs=conn.execute(sql)%><body><tablewidth="1100"border="1"align="center"cellpadding="1"cellspacing="0"><trvalign="top"class="Band"bgcolor="#D4D0C8"><tdheight="34"colspan="10"align="center"valign="middle"nowrap="nowrap"><pclass="STYLE4"></p></td></tr><trvalign="top"class="Band"bgcolor="#D4D0C8"><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"><spanclass="STYLE11">统计时间</span></td><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"><spanclass="STYLE11">记录类型</span></td><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"><spanclass="STYLE11">类别</span></td><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"><spanclass="STYLE11">分类</span></td><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"><spanclass="STYLE11">统计值</span></td><tdwidth="100"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"><spanclass="STYLE11">标准值</span></td></tr><%while(notrs.eof)If(CDBL(RS("TJZ"))<CDBL(RS("BZZ")))AndCDBL(RS("TJZ"))<>-1ThenCOL="#FF0000"ElseCOL="#FFFFFF"EndIF%><trvalign="top"class="Band"><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"bgcolor=<%=COL%>><%=rs("TJSJ")%></td><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"bgcolor=<%=COL%>><%=rs("JLLX")%></td><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"bgcolor=<%=COL%>><%=rs("LB")%></td><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"bgcolor=<%=COL%>><%=rs("FL")%></td><tdwidth="200"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"bgcolor=<%=COL%>><%=rs("TJZ")%></td><tdwidth="100"height="20"colspan="1"align="center"valign="middle"nowrap="nowrap"bgcolor=<%=COL%>><%=rs("BZZ")%></td></tr><%rs.movenextwend%></table><%rs.closeconn.close%></body></html>
解决方案
本帖最后由 lunatic_vip 于 2011-12-20 17:14:36 编辑
解决方案二：
你这是asp吧换个asp版问问吧