穿越路西菲尔全文txt:ASP编程中error number:-2147217900错误如何解决?求高手指点一下!!

来源:百度文库 编辑:高校问答 时间:2024/04/30 03:26:34
ASP编程当中碰上insert into 的错误,错误号是 -2174217900,提示是语法错误,在下查看了SQL 的insert into 语句并不错误,请高手帮忙分析一下:
error number:-2147217900是什么意思?
ASP编程中error number:-2147217900错误如何解决?求高手指点一下!!
dim sex,password,address,shouji,phone,dianhuahao,name2
dim QQ,xueli,email,birdate
name2 = trim(request("name"))
sex = request("sex")
password = trim(request("password1"))
address = trim(request("address"))
shouji = trim(request("shouji"))
phone = trim(request("phone"))
QQ = trim(request("QQ"))
xueli = request("rank")
birdate = request("birdate")
email = trim(request("email"))
sqladd="insert into register(userid,name,password,sex,address,shouji,dianhuahao,rank,qq,birdate,email)values('"& dataid &"','"& name2 &"','"& password &"','"& sex &"','"& address &"','"& shouji &"','"& dianhuahao &"','"& xueli &"','"& QQ &"','"& birdate &"','"& email &"')"
求各位高手给看看,为什么老是报insert into 语法错???

字段值与字段类型不匹配

你有数值为空,造成类似 aaa = and bbb = ccc 中aaa=后面没值的错误