为什么SQL与ASP编程 rs.addnew 加不进数据到数据库

来源:百度知道 编辑:UC知道 时间:2024/06/24 04:49:48
'添加
Public Sub SendNews()
On Error Resume Next
Dim CanNext
CanNext = True
'检查该版块是否设置开放
If LCase(NewsOption) <> "open" Then
CanNext = False
TkMsg "对不起,该版块已设置为关闭状态,若要开放,请联系管理员!", ""
End If
Dim Title, EnTitle, Content, EnContent, SqlStr, Sql, Rs, rStr, SpSqlStr, SpRstr, ri,zn
Title = Trim(Request.Form("Title"))
zn = Trim(Request.Form("zn"))
Content = Replace(Trim(Request.Form("Content")), "../UpLoadFile/", "UpLoadFile/")

Sql = "select * from [News]"
Set Rs = Server.CreateObject("adodb.recordset")
Rs.Open Sql, Conn, 1, 3
Rs.Addnew
Rs("Title") = Title
Rs("Content") = Content
Rs("zn") = zn
Rs("AddDate") =date()
Rs.Update
Rs.Close
Set Rs = Nothing
TkMsg &q

你去掉On Error Resume Next 这句屏蔽出错的语句,看看是否会出错,后在调试

你这里完全没必要用RS去insert,浪费系统资源
用conn.execute("insert into...")
就可以了