急等,如何更改下面的这段代码?
这是网站后台添加新闻的代码。在调试时显示错误。显示“rs.update”这一行有错误。请大家来指点一下。应该如何更改
<!--#include file="jfgmnv.asp"-->
<%
if session("aleave")="" then
response.redirect "adminlogin.asp"
response.end
end if
%>
<%
title=request("title")
BigClassName=request("BigClassName")
SmallClassName=request("SmallClassName")
mContent = trim(Request.form("cnWords"))
mimageNum = Request.form("imageNum")
firstImageName = trim(Request.form("editFirstImageName"))
user=request("user")
ok=request("ok")
hits=request("hits")
postuser=session("admin")
set rs=server.createobject("adodb.recordset")
sql="select * from NEWS where (id is null)"
rs.open sql,conn,1,3
rs.addnew
rs("postuser")=postuser
rs("title")=title
rs("content")=mcontent
rs("user")=user
rs("hits")=hits
rs("BigClassName")=BigClassName
rs("SmallClassName")=SmallClassName
if ok then
rs("imageNum") = "1"
rs("ok")=true
else
rs("imageNum") = "0"
rs("ok")=false
end if
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.write "<script language='javascript'>" & chr(13)
response.write "alert('新闻提交成功!');" & Chr(13)
response.write "window.document.location.href='admin_info.asp';"&Chr(13)
response.write "</script>" & Chr(13)
Response.End
%>
有朋友说要用conn.execute执行
insert into news values.....来添加数据
无奈本人的知识有限。希望大家帮忙。