<!--#include file="../conn.asp"-->
<%
action=Trim(Request.QueryString("save"))

title=Trim(Request.Form("title"))'文本型
classID=Trim(Request.Form("classID"))'数字型
Opens=Trim(Request.Form("open"))'逻辑是否型
show=Trim(Request.Form("show"))'数字型
content=Trim(Request.Form("content"))'备注型

sql="Insert into article (regid,title,content,classno,Open,show) values("&RegId&",'"&title&"','"&content&"',"&classID&","&opens&","&show&")"
conn.execute(sql)

response.write title&"<br>"&classID&"<BR>"&opens&"<br>"&show&"<br>"&content&"<br> 用户ID："&regid &"<br>"&action
%>
所有值都能获取到，就是不能写入数据库。这是什么缘故？

有什么提示没有?

看看sql语句是否正确。

Microsoft JET Database Engine 错误 '80040e14'

INSERT INTO 语句的语法错误。

/menber/article_save.asp，行 21

sql="Insert into article (regid,title,content,classno,Open,show) values("&RegId&",'"&title&"','"&content&"',"&classID&","&opens&","&show&")"
conn.execute(sql)

这语句哪里错了

open和show可能是关键字，改成[open]、[show]试试

<!--#include file="../conn.asp"-->
<%
action=Trim(Request.QueryString("save"))

title=Trim(Request.Form("title"))'文本型
classID=Trim(Request.Form("classID"))'数字型
Opens=Trim(Request.Form("open"))'逻辑是否型
show=Trim(Request.Form("show"))'数字型
content=Trim(Request.Form("content"))'备注型

Dim rsIns
Set rsIns=Server.CreateObject("ADODB.RecordSet")
rsIns.Open "select * from article",conn,1,3
rsIns.AddNew
rsIns("regid")=RegId
rsIns("title")=title
rsIns("content")=content
rsIns("classno")=CInt(classID)
rsIns("Open")=opens
rsIns("show")=CInt(show)
rsIns.Update
rsIns.Close
Set rsIns=Nothing
response.write title&"<br>"&classID&"<BR>"&opens&"<br>"&show&"<br>"&content&"<br> 用户ID："&regid &"<br>"&action
%>

照楼上这样做肯定是没有问题的!

在2003server打了一些补丁后,insert into根本没法用.上次就遇到这种情况,本来是好好的,系统升级后就出问题了,最后全改成Addnew就行了.也不知道怎么回事!

sql="Insert into article (regid,title,content,classno,Open,show) values('"&RegId&"','"&title&"','"&content&"','"&classID&"','"&opens&"','"&show&"')"
conn.execute(sql)


帮你改好了,试试看,应该没有问题了吧,有问题再提

谢谢各位好友的解答，经过测试，证实并非 SQL语句错误，而是ACCESS的一个BUG ，对于在线编辑器中的 数据 如果含有 日本片假名 就会报错 Microsoft JET Database Engine 错误 '80040e14' 。
我最后把那写 日本假名 全部过滤后，能正常添加数据了。
------------------------------------------------------------------------------------------------------
contents=replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(content,"ガ",""),"ギ ",""),"グ",""),"ゲ",""),"ゴ",""),"ザ ",""),"ジ",""),"ズ",""),"ゼ",""),"ゾ","")," ダ",""),"ヂ",""),"ヅ",""),"デ",""),"ド",""),"バ",""),"ビ",""),"ブ",""),"ベ",""),"ボ",""),"パ",""),"ピ","")," プ",""),"ペ",""),"ポ ",""),"ヴ",""),"'","")