admin_researchsave.asp

3000首FLASH源程序

<!--#include file="conn.asp"-->
<!--#include file="function.asp"-->
<%CheckAdmins%>
<%
ID=request.QueryString("id")
Title=trim(request.form("Title"))
DateAndTime=trim(request.form("DateAndTime"))
act=request("act")
if DateAndTime="" then DateAndTime=now()
Content=trim(request.form("Content"))
founerr=false
if Title="" then
	errmsg="<li>调查主题不能为空</li>"
	founderr=true
end if

if founderr=true then
	call error()
else
	set rs=server.createobject("adodb.recordset")
	if act="edit" then
		sql="select * from research where ID="&ID
	elseif act="add" then
		sql="select * from research"
	else
		errmsg="<li>操作错误！请联系管理员</li>"
		call error()
		Response.End 
	end if
	rs.open sql,conn,1,3
	if act="add" or act="edit" then
		if act="edit" then
			if rs.eof then
				errmsg="<li>操作错误！请联系管理员</li>"
				call error()
				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)=request("select"&i)
				if request("answer"&i)="" then
					rs("answer"&i)=0
				else
					rs("answer"&i)=request("answer"&i)
				end if
			end if
		next
		rs("DateAndTime")=DateAndTime
		rs.update
	end if
	rs.close
	set rs=nothing
	conn.close
	set conn=nothing
	Response.Redirect "admin_ResearchMana.asp"
end if
%>
</body>
</html>