Question

asp插入数据库问题

<%
if request.QueryString("liu")="liu" then
dim Ltitle,rsw,strsql,Lname,Lemail,LQQ,Ldizhi,Contect,sqlw
Ltitle=CheckStr(trim(request.form("Ltitle")))
Lname=CheckStr(trim(request.form("Lname")))
Lemail=CheckStr(trim(request.form("Lemail")))
LQQ=CheckStr(trim(request.Form("LQQ")))
Ldizhi=CheckStr(trim(request.Form("Ldizhi")))
Contect=CheckStr(trim(request.form("Contect")))
set rsw=server.createobject("adodb.recordset")
sqlw="insert into Liuyan(Lname,Ltitle,Lemail,LQQ,Ldizhi,Contect) Values ('"&Lname&"','"&Ltitle&"','"&Lemail&"','"&LQQ&"','"&Ldizhi&"','"&Contect&"')"
rsw.open sqlw,conn,1,1
response.write("<script language='javascript'>alert('留言成功，等待管理员审核！');location.href='message.asp'</script>")

怎么没有插入到数据库里啊
if request.QueryString("liu")="liu" then
dim Ltitle,rsw,strsql,Lname,Lemail,LQQ,Ldizhi,Contect,sqlw
Ltitle=CheckStr(trim(request.form("Ltitle")))
Lname=CheckStr(trim(request.form("Lname")))
Lemail=CheckStr(trim(request.form("Lemail")))
LQQ=CheckStr(trim(request.Form("LQQ")))
Ldizhi=CheckStr(trim(request.Form("Ldizhi")))
Contect=CheckStr(trim(request.form("Contect")))
sqlw="insert into Liuyan(Lname,Ltitle,Lemail,LQQ,Ldizhi,Contect) Values ('"&Lname&"','"&Ltitle&"','"&Lemail&"','"&LQQ&"','"&Ldizhi&"','"&Contect&"')"
conn.execute(sqlw)
response.write("<script language='javascript'>alert('留言成功，等待管理员审核！');location.href='message.asp'</script>")
else

Answer 1

既然是用insert into语句，把
set rsw=server.createobject("adodb.recordset")
sqlw="insert into Liuyan(Lname,Ltitle,Lemail,LQQ,Ldizhi,Contect) Values ('"&Lname&"','"&Ltitle&"','"&Lemail&"','"&LQQ&"','"&Ldizhi&"','"&Contect&"')"
rsw.open sqlw,conn,1,1
改为：
sqlw="insert into Liuyan(Lname,Ltitle,Lemail,LQQ,Ldizhi,Contect) Values ('"&Lname&"','"&Ltitle&"','"&Lemail&"','"&LQQ&"','"&Ldizhi&"','"&Contect&"')"
conn.execute(sqlw)

Answer 2

recordset只能打开一个有返回记录集的查询语句,insert 语句要用connection或command执行.如conn.execute(sqlw)