%@language=vbscript codepage=936 %> <% dim Title,VoteTime,Action,IsSelected dim rs,sql Title=trim(request.form("Title")) VoteTime=trim(request.form("VoteTime")) if VoteTime="" then VoteTime=now() Action=trim(request("Action")) IsSelected=trim(request("IsSelected")) dim i if Title<>"" then sql="select top 1 * from Vote" Set rs= Server.CreateObject("ADODB.Recordset") rs.open sql,conn,1,3 rs.addnew rs("Title")=Title for i=1 to 8 if trim(request("select"&i))<>"" then rs("select"&i)=trim(request("select"&i)) if request("answer"&i)="" then rs("answer"&i)=0 else rs("answer"&i)=clng(request("answer"&i)) end if end if next rs("VoteTime")=VoteTime rs("VoteType")=request("VoteType") if IsSelected="" then IsSelected=false if IsSelected="True" then conn.execute "Update Vote set IsSelected=False where IsSelected=True" rs("IsSelected")=IsSelected rs.update rs.close set rs=nothing call CloseConn() Response.Redirect "VoteManage.asp" end if %>
添 加 调 查 |