asp中数据提交问题

来源:百度知道 编辑:UC知道 时间:2024/05/11 02:46:17
<form action="shtg.asp" method="POST" name="input" LANGUAGE="javascript" onsubmit="return

input_onsubmit()">
<table>
<tr><td width="25%">报表文件</td><td width="16%">报表月份</td><td width="16%">报表年度</td><td

width="16%">详细资料</td><td width="16%">审核状态</td><td width="16%">现在审核</td>
</tr>
<%
set rs=server.CreateObject("ADODB.Recordset")
sql="select * from sj where sh='未审核' "
rs.open sql,conn,1,3
rs.movelast
if not rs.bof then
while not rs.bof
response.write("<tr>")
response.write("<td>" & rs("mc") & "</td>")
response.write("<td>" & rs("yue") & "</td>")
response.write("

改为
<%
set rs=server.CreateObject("ADODB.Recordset")
sql="select * from sj where sh='未审核' "
rs.open sql,conn,1,3
rs.movelast
if not rs.bof then
while not rs.eof '修改的地方
response.write("<tr>")
response.write("<td>" & rs("mc") & "</td>")
response.write("<td>" & rs("yue") & "</td>")
response.write("<td>" & rs("nian") & "</td>")
response.write("<td><a href=" & rs("cz") & ">下载</a></td>")
response.write("<td>" & rs("sh") & "</td>")
%>