求助!插入数据库insert错误,哪为大虾帮帮忙!

来源:百度知道 编辑:UC知道 时间:2024/05/31 21:38:57
<%
prior = Request("prior");
people = Request("people");
area = Request("area");
danweixingzhi = Request("danweixingzhi");
money = Request("money");
idea = Request("idea");
complany = Request("complany");
address = Request("address");
uname = Request("uname");
telephone = Request("telephone");
mobile = Request("mobile");
email = Request("email");
content = Request("content");

//Response.End();
conn=Server.CreateObject("ADODB.Connection");
conn.Open("driver={Microsoft Access Driver (*.mdb)};dbq="+Server.MapPath("db1.mdb"));
sql = "insert into qqm(prior,people,area,danweixingzhi,money,idea,complany,address,uname,telephone,mobile,email,content) values('"+prior+"','"+people+"&#

检查所有插入的字段,是否有request为空但是数据库不允许为空的字段,检查字段的类型。字符串需要加'text'插入。

只能看到这么多了。

是的。检查字段提交的SQL语句