<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from 本站首页"
rs.open sql,conn,1,3
rs.addnew
rs(session("name"))=request("标题")
rs(session("name")&"内容")=request("正文内容")
rs(session("name")&"时间")=request("date")
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
if session("name")="专题新闻" then
%>
<!--#include file="../upload/up.asp"-->
<%
else
response.Redirect("new.asp?ck=y")
end if
%>
../upload/up.asp页面
<%
strConn = "Driver={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("../database/office.mdb")
session("strconn")=strConn
Set dbc = Server.CreateObject("ADODB.Connection")
dbc.open strConn
set rs=server.CreateObject("adodb.recordset")
rs.Open "SELECT * FROM upload",dbc,1,3