UC知道ASP连接数据库的问题提示231行错误
来源：百度知道 编辑：UC知道 时间：2024/05/24 07:04:30
set rs = nothing
else
U_username = request.form("username")
U_password = request.form("password")
U_question = request.form("question")
U_answer = request.form("answer")
U_email = request.form("email")
U_cname = request.form("cname")
U_cyear = request.form("cyear")
U_cmonth = request.form("cmonth")
U_cday = request.form("cday")
U_check = request.form("check")
U_mphone = request.form("mphone")
U_qq = request.form("qq")
exec = "insert into usertab ([username],[password],[question],[answer],[email],[cname],[cyear],[cmonth],[cday],[check],[mphone],[qq]) values ('"+U_username+"','"+U_password+"','"+U_question+"','"+U_answer+"&#
else
U_username = request.form("username")
U_password = request.form("password")
U_question = request.form("question")
U_answer = request.form("answer")
U_email = request.form("email")
U_cname = request.form("cname")
U_cyear = request.form("cyear")
U_cmonth = request.form("cmonth")
U_cday = request.form("cday")
U_check = request.form("check")
U_mphone = request.form("mphone")
U_qq = request.form("qq")
exec = "insert into usertab ([username],[password],[question],[answer],[email],[cname],[cyear],[cmonth],[cday],[check],[mphone],[qq]) values ('"+U_username+"','"+U_password+"','"+U_question+"','"+U_answer+"&#
exec = "insert into usertab ([username],[password],[question],[answer],[email],[cname],[cyear],[cmonth],[cday],[check],[mphone],[qq]) values ('"+U_username+"','"+U_password+"','"+U_question+"','"+U_answer+"','"+U_email+"','"+U_cname+"','"+U_cyear+"','"+U_cmonth+"','"+U_cday+"','"+U_check+"','"+U_mphone+"','"+U_qq+"')"
这里面的字段顺序必须要和数据库里的顺序一样，否则是错误的。
工具-文件夹选项-使用简单文件共享： 去掉这个的勾
对数据库文件按右键-属性-安全-添加一个用户“everyone”，勾上对应权限