请高手帮忙!!!
<%
n=request.Form("tiaocha")
if n="" then
%>
<script language="VBScript">
msgbox "不能为空!"
window.location.href=("daochabiao.htm")
</script>
<%
else
set conn=server.CreateObject("adodb.connection")
conn.connectionstring="provider=sqloledb.1;uid=sa;pwd=;initial catalog=diaochabiao;data source=pc125"
conn.open
set rst=server.CreateObject("adodb.recordset")
dim sql
sql="select * from diaochabiao"
rst.open sql,conn,2,2
dim counter(4)
for i=0 to rst.fields.count-1
counter(i)=cint(rst.fields(i).value)
next
t=counter(n)
t=t+1
sql="update diaochabiao set "&rst.fields(n).name&"="&t
rst.open sql,conn,2,2
end if
请确认可行再回复谢谢!!