savevote.asp

来自「网上购物,不错的购物系统,花了好长时间来改的」· ASP 代码 · 共 50 行

<!--#include file="conn.asp"-->
<%
dim id,title,act,DateAndTime,Content,sql,i
ID=request.QueryString("id")
Title=trim(request.form("Title"))
act=request("act")
if DateAndTime="" then DateAndTime=now()
Content=trim(request.form("Content"))
if Title="" then
response.write "<script language=javascript>alert('主题不能为空!');history.go(-1);</script>"
response.end
end if

	set rs=server.createobject("adodb.recordset")
	if act="edit" then
		sql="select * from sh_toupiao where ID="&ID
	elseif act="add" then
		sql="select * from sh_toupiao"
	end if
	rs.open sql,conn,1,3
	if act="add" or act="edit" then
		if act="edit" then
			if rs.eof then
			response.write "<script language=javascript>alert('操作错误！');history.go(-1);</script>"
			Response.End 
			end if
		end if
		if act="add" then rs.addnew
		rs("Title")=Title
		for i=1 to 8
		if request("select"&i)="" then
		rs("select"&i)=""
		else
		rs("select"&i)=request("select"&i)
		end if
		if request("answer"&i)="" then
		rs("answer"&i)=0
		else
		rs("answer"&i)=request("answer"&i)
		end if
		next
		rs("dateandtime")=now()
		rs.update
	end if
	rs.close
	set rs=nothing
	conn.close
	set conn=nothing
	Response.Redirect "ManageVote.asp"
%>