Question

ASP中怎样实现向access数据库中添加记录啊？

Answer 1

gRS.Open
"select
*
from
search
order
by
id
asc",gConn,1,1
'打开记录集
If
not(gRS.BOF
and
gRS.EOF)
then
'判断是否有记录
Response.write
"记录已存在。"
else
gRS.Addnew
'添加新记录
gRS("表项")=Request.Querystring("stxt")
'赋值
gRS.Update
'更新
Response.write
"记录已添加。"
end
if
gRS.Close
'关闭连接
gConn.Close

Answer 2

exec="insert
into
new(news_title,news_shorttitle,news_from,news_writer,news_introduction,news_comment,news_keys,news_pic,news_class)values('"&news_title&"',"&news_shorttitle&"',"&news_from&"',"&news_writer&"',"&news_introduction&"',"&news_comment&"',"&news_keys&"',"&news_pic&"',"&news_class&"')"
这语句有错误.!!
,"&news_shorttitle&"',象这样的..右边有单引号.左边的单引号那里去了。补上去.就可以拉.
,'"&news_shorttitle&"',
所有缺单引号的都补上去