新微赢技术网

标题: conn.execute exec 语法错误, [打印本页]

作者: 为你执著 时间: 2010-1-16 04:14
标题: conn.execute exec 语法错误,
<%
if name<>"" then
a1=request.form("name")
a2=request.form("psw")
a3=request.form("psw1")
if a2<>a3 then
response.write("两次输入密码不一至,可能会导致您无法正常登录,请<a href='zhuceyi.asp'>返回</a>重新输入")
else
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("data/diansibalist.mdb")
name=request.form("name")
psw=request.form("psw")
bsd=request.form("bsd")
tel=request.form("tel")
ttel=request.form("ttel")
email=request.form("email")
adr=request.form("adr")
message=request.form("message")
exec="insert into classlist(name,psw,bsd,tel,ttel,email,qq,adr)values('"&name&"','"&psw&"','"&bsd&"',"&tel&","&ttel&",'"&email&"',"&qq&",'"&adr&"')"
response.write exec
conn.execute exec <----显视是这里错误
conn.close
set conn=nothing
response.write "记录添加成功!"
end if
else
response.write("你输入的资不全,请<a href='zhuceyi.asp'>返回</a>重新输入")
end if
%>

欢迎光临新微赢技术网 (http://bbs.weiying.cn/)