谁能告诉我下面程序哪里语法错了啊dim struser,strpwd,strname,strnumb,strad,stredu,strlovestruser=request.form("txtuser")strpwd=request.form("txtpwd")strname=request.form("txtname")if request.form("txtnumb")""thenstrnumb=request.form("tx

来源:学生作业帮助网 编辑:作业帮 时间:2024/05/09 18:28:18
谁能告诉我下面程序哪里语法错了啊dim struser,strpwd,strname,strnumb,strad,stredu,strlovestruser=request.form(

谁能告诉我下面程序哪里语法错了啊dim struser,strpwd,strname,strnumb,strad,stredu,strlovestruser=request.form("txtuser")strpwd=request.form("txtpwd")strname=request.form("txtname")if request.form("txtnumb")""thenstrnumb=request.form("tx
谁能告诉我下面程序哪里语法错了啊
dim struser,strpwd,strname,strnumb,strad,stredu,strlove
struser=request.form("txtuser")
strpwd=request.form("txtpwd")
strname=request.form("txtname")
if request.form("txtnumb")""then
strnumb=request.form("txtnumb")
else
strnumb=0
end if
strad=request.form("txtad")
stredu=request.form("rdoedu")
strlove=request.form("chklove")
dim conn,strconn
set conn=server.createobject("ADODB.Connection")
strconn="provider=microsoft.jet.OLEDB.4.0;data source=" & server.mappath("address.mdb")
conn.open strconn
dim strsql
strsql="insert into user(struser,strpwd,strname,strnumb,strad,stredu,strlove) values('" & struser & "','" & strpwd & "','" & strname & "','" & strnumb &"','" & strad & "','" & stredu & "','" & strlove & "')"
conn.execute(strsql)
response.redirect"denglu.asp"
提示的是strsql="insert into user(struser,strpwd,strname,strnumb,strad,stredu,strlove) values('" & struser & "','" & strpwd & "','" & strname & "','" & strnumb &"','" & strad & "','" & stredu & "','" & strlove & "')"语法错误

谁能告诉我下面程序哪里语法错了啊dim struser,strpwd,strname,strnumb,strad,stredu,strlovestruser=request.form("txtuser")strpwd=request.form("txtpwd")strname=request.form("txtname")if request.form("txtnumb")""thenstrnumb=request.form("tx
报什么错呢,插入数据库时注意值与字段类型是否匹配