数据添加成功,但是数据库内无内容

来源:百度知道 编辑:UC知道 时间:2024/06/17 12:37:49
<%
username=request.Form("username")
passwrod=request.Form("password")
email=request.Form("email")
name=request.Form("name")
passcode=request.Form("passcode")
addr=request.Form("addr")
tel=request.Form("tel")
mov=request.Form("mov")
fax=request.Form("fax")
postcode=request.Form("postcode")
bz=request.Form("bz")

set conn= server.createObject("adodb.connection")
conn.open "Provider=Microsoft.jet.OLEDB.4.0;data source=" & server.MapPath("fifasp.mdb")
sql="insert into user (username,password,email,name,passcode,addr,tel,mov,fax,postcode,bz) values('"&username&"','"&password&"','"&email&"','"&name&"','"&passcode&"','"&addr&"','"&tel&"&#

<%
username=request.Form("username")
passwrod=request.Form("password")
email=request.Form("email")
name=request.Form("name")
passcode=request.Form("passcode")
addr=request.Form("addr")
tel=request.Form("tel")
mov=request.Form("mov")
fax=request.Form("fax")
postcode=request.Form("postcode")
bz=request.Form("bz")

set conn= server.createObject("adodb.connection")
conn.open "Provider=Microsoft.jet.OLEDB.4.0;data source=" & server.MapPath("fifasp.mdb")
sql="insert into user (username,password,email,name,passcode,addr,tel,mov,fax,postcode,bz) values('"&username&"','"&password&"','"&email&"','"&name&"','"&passcode&"','"&addr&"','"&tel&"