specialadd.asp

ASP+SQL2000+

<!--#INCLUDE FILE="Conn.asp" --><!--#include file=../include/config.asp-->
<%
IF not(request.cookies("KEY")="super" or request.cookies("KEY")="bigmaster" or request.cookies("KEY")="check" or request.cookies("key")="typemaster") THEN
response.write "<script>alert('您无权添加此项目！');history.go(-1);</Script>"
response.end
END IF	
function changechr(str) 
    changechr=replace(replace(replace(replace(str,"<","&lt;"),">","&gt;"),chr(13),"<br>")," ","&nbsp;") 
    changechr=replace(changechr,"'","&quot;")
    changechr=replace(changechr,mid(" "" ",2,1),"&quot;")
end function

dim Specialname
specialzs=request.form("specialzs")
Specialname=changechr(trim(request("Specialname")))
If Specialname="" Then
response.write "不能为空！"
response.end
end if
set rs=server.createobject("adodb.recordset")
sql="select * from Special"
rs.open sql,conn,3,3
do while not rs.eof
if rs("Specialname")=Specialname then
response.write "已经存在这个专题！请<a href=javascript:history.go(-1)>返回重新填写</a>！"
response.end
end if
rs.movenext
loop
rs.close
set rs=nothing
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from Special"
rs.open sql,conn,3,3
rs.addnew
rs("Specialname")=Specialname
rs("Specialzs")=Specialzs
rs("Specialmaster")=request.cookies("username")
rs.update
rs.close
set rs=nothing


conn.close
set conn=nothing
response.write "<p align=center><font color=red>恭喜您!添加专题“"&Specialname&"”成功!<br>"&freetime&"秒钟后返回上页!</font>"
response.write "<meta http-equiv=""refresh"" content="""&freetime&";url=Special.asp"">"
%>