高考问答穷人作文续写450字:aSP添加数据的问题!
来源：百度文库 编辑：高考问答 时间：2024/05/05 19:05:15
<%
set conn = server.CreateObject("adodb.connection")
on error resume next
conn.Open "driver={microsoft access driver (*.mdb)}; dbq=" & server.MapPath("newsboard.mdb")
%>
<%
title=request.form("title")
name=request.form("bumen")
text=request.Form("text")
exec="INSERT INTO news(title,bumen,text)values('"&title&"','"&bumen&"','"&text&"')"
conn.execute(exec)
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
显示"记录添加成功!"但是数据库中没有看到啊 !救命!!!
set conn = server.CreateObject("adodb.connection")
on error resume next
conn.Open "driver={microsoft access driver (*.mdb)}; dbq=" & server.MapPath("newsboard.mdb")
%>
<%
title=request.form("title")
name=request.form("bumen")
text=request.Form("text")
exec="INSERT INTO news(title,bumen,text)values('"&title&"','"&bumen&"','"&text&"')"
conn.execute(exec)
conn.close
set conn=nothing
response.write "记录添加成功!"
%>
显示"记录添加成功!"但是数据库中没有看到啊 !救命!!!
你把“on error resume next ”去掉再调试吧，要不你怎么都不会看到报错的。
db_type="ms access"
db_path=server.mappath(".")
connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&Server.MapPath(db_path&"test/testforvain.mdb") & ";Jet OLEDB:DATABASE;"
set conn= Server.CreateObject("ADODB.Connection")
conn.Open connstr
你这样打开数据库再看看