UC知道ASP运行出错：0x800A0E7D
来源：百度知道 编辑：UC知道 时间：2024/05/30 07:33:15
<html>
<head>
<title>添加新词语</title>
</head>
<body>
<% dim conn,newword,js,yy,lx,bz,action
set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};datebase=webdata;server=(local);uid=sa;pwd="
newword=request.form("newword")
js=request.form("js")
yy=request.form("yy")
lx=request.form("lx")
bz=request.form("bz")
response.write "单词:"& newword &"<br>"
response.write "注释:"& js &"<br>"
response.write "应用:"& yy &"<br>"
response.write "类型:"& lx &"<br>"
response.write "备注:"& bz
response.write "确认将这些信息加入到数据库吗？"
action=request.QueryString("action")
conn.close
if action=add then
set rs=server.createobject("adodb.recordset&qu
<head>
<title>添加新词语</title>
</head>
<body>
<% dim conn,newword,js,yy,lx,bz,action
set conn=server.createobject("adodb.connection")
conn.open "driver={sql server};datebase=webdata;server=(local);uid=sa;pwd="
newword=request.form("newword")
js=request.form("js")
yy=request.form("yy")
lx=request.form("lx")
bz=request.form("bz")
response.write "单词:"& newword &"<br>"
response.write "注释:"& js &"<br>"
response.write "应用:"& yy &"<br>"
response.write "类型:"& lx &"<br>"
response.write "备注:"& bz
response.write "确认将这些信息加入到数据库吗？"
action=request.QueryString("action")
conn.close
if action=add then
set rs=server.createobject("adodb.recordset&qu
以我做数据库的经验，尽量少用rs.update等可以更新数据集，
你可以把sqlstr = "insert into word values('"+newword +"','"+js+"','"+yy+"','"+lx+"','"+bz+"')"
rs.open sqlstr,conn,1,1
这样来做插入执行
可能会更好一点，
conn.open "driver={sql server};datebase=webdata;server=(local);uid=sa;pwd="
数据库名称？？