asp中关于投票系统的问题请帮帮忙谢了!
<%
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
update diaochabiao set rst.fields(n).value=rst.fields(n).value+1
end if
%>
我知道下面的语句出了错介不知应该怎么改:
update diaochabiao set rst.fields(n).value=rst.fields(n).value+1
请帮忙指点谢了!!