UC知道access插入语句
来源：百度知道 编辑：UC知道 时间：2024/05/31 23:42:52
<%
username=request.form("username")
password=request.form("password")
cpassword=request.form("cpassword")
telephone=request.form("telephone")
email=request.form("email")
shopname=request.form("shopname")
shopadress1=request.form("shopadress1")
shopadress2=request.form("shopadress2")
shopadress3=request.form("shopadress3")
shopjieshao=request.form("shopjieshao")
if username<>"" then
conn.execute "insert into shanghujibenxinxi (User,Password,cPassword,telephone,email,Username,Useraddress1,Useraddress2,Useraddress3,Userneirong) values('"+username1+"','"+password+"','"+cpassword+"',"+telephone+",'"+email+"','"+shopname+"','"+shopadress1+"','"+shopadress2+"','"
username=request.form("username")
password=request.form("password")
cpassword=request.form("cpassword")
telephone=request.form("telephone")
email=request.form("email")
shopname=request.form("shopname")
shopadress1=request.form("shopadress1")
shopadress2=request.form("shopadress2")
shopadress3=request.form("shopadress3")
shopjieshao=request.form("shopjieshao")
if username<>"" then
conn.execute "insert into shanghujibenxinxi (User,Password,cPassword,telephone,email,Username,Useraddress1,Useraddress2,Useraddress3,Userneirong) values('"+username1+"','"+password+"','"+cpassword+"',"+telephone+",'"+email+"','"+shopname+"','"+shopadress1+"','"+shopadress2+"','"
('"&username&"','"&password&"','"&cpassword&"',"&telephone&",'"&email&"','"&shopname&"','"&shopadress1&"','"&shopadress2&"','"&shopadress3&"','"&shopjieshao&"')"
不建议你使用这种方法，建议你使用一下语句
set rs=server.creatobject("adodb.recordset")
sql="select * from shanghujibenxinxi"
rs.open sql,conn,1,3
rs.addnew
rs("User")=username
...
rs("Userneirong")=shopjieshao
rs.update
rs.close
set rs=nothing
这样以后改起来也好改
不知道楼主是什么数据库要是SQL2000的话你在查询器里写一下
看一看你的插入语句行吗
insert into shanghujibenxinxi (User,Password,cPassword,telephone,email,Username,Useraddress1,Useraddress2,Useraddress3,Userneirong) values('"+username1+"','"+password+"','"+cpassword+"',"+telephone+