Question

INSERT INTO 语句的语法错误。是什么原因？

源代码是：Dim CommentsID,contentID,Commentator,CommentContent,AddTime,CommentIP,CommentStatus if getForm("code","post")<>Session("Code") then alertMsgAndGo "验证码不正确","-1" contentID=filterPara(getForm("contentID","post")) Commentator=filterPara(getForm("Commentator","post")) CommentContent=encode(filterPara(getForm("CommentContent","post"))) CommentIP=getIP() CommentStatus=0 if not IsSafeStr(Commentator) then alertMsgAndGo "评论人里包含了不安全字段，请重新输入","-1" if isnul(Commentator) then alertMsgAndGo "评论者不能为空","-1" if isnul(CommentContent) then alertMsgAndGo "评论内容不能为空","-1" Conn.exec "insert into Aspcms_Comments (content_ID,Comment_ator,Comment_Content,Add_Time,Comment_IP,Comment_Status)valuas("&contentID&",'"&Commentator&"','"&CommentContent&"','"&now()&"','"&CommentIP&"',"&CommentStatus&")","exe"

提交评论后总是

求高手指导呀，摸索了一晚上头都大了

Answer 1

我怎么发现你插入数据的列和数据部对应，你的字段6个，而你的数据值只有5个。

追问

哎，还是弄不懂，都是些奸商，软件功能不弄齐全就拿出来发布赚钱，Aspcms这评论功能都调用不了。