Question

数据库无法写入

语句输出是这个
sql="insert into admin (user,pwd,lx) values('"&addusername&"','"&addpassword&"','"&lx&"')"
conn.Execute(sql)
结果
insert into admin (user,pwd,lx) values('asdf','asdf','1')
err输出是这个
-2147217900

Answer 1

<%
user=request.form("addusername")
pwd=request.form("addpassword")
lx=request.form("lx")

set conn=server.createobject("adodb.connection")
sql="select * from 表的名称"
rs.open sql,conn,1,3
rs.addnew
rs("user")=user
rs("pwd")=pwd
rs("lx")=lx
rs.update
rs.close
set rs=nothing

conn.close
set conn=nothing
%>

Answer 2

dim addusername,addpassword,lx

addusername=trim(request("xxx"))
addpassword=trim(request("xxx"))
lx=trim(request("xxx")))

conn.execute("insert into admin (user,pwd,lx) values('"&addusername&"','"&addpassword&"','"&lx&"')" )