注册 登录
编程论坛 ASP技术论坛

插入问题

威龙嘉少 发布于 2007-11-25 20:22, 598 次点击
if request.form("send")="发表" then
title=request.form("title")
neirong=request.form("Content")
author=request.form("author")
classid=request.form("class")
from=request.form("from")
response.Write(title)
response.Write(neirong)
response.Write(from)
conn.execute "insert into article(title,neirong,from,author,class,vtime) values('"&title&"','"&neirong&"','"&from&"','"&author&"',"&classid&",0)"
if conn.errors.count>0 then
   response.write("error")  
end if
response.write "<script language='javascript'>"
response.write "alert('添加成功!');"
response.write "location.href='javascript:history.go(-1)';"      
response.write "</script>"
end if
我这样插入一段文章,操作没有错误,可是就是数据库里什么内容都没有?
请指教!
2 回复
#2
madpbpl2007-11-25 21:05
response.Write(title)
response.Write(neirong)
response.Write(from)
response.write Request.form("send")
这几个的值都能得到吗?还有看看from class是不是数据库保留字。
#3
yms1232007-11-25 21:19
insert into article(title,neirong,[from],author,[class],vtime) values
from是数据库保留关键字,用作字段名称要加[]的。
1