UC知道这些asp写入access数据库的代码有什么问题
来源：百度知道 编辑：UC知道 时间：2024/09/27 19:27:39
数据库连接文件代码：
<%set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("message_#book.asp")
%>
写入数据库文件代码：
<!--#include file="/data/conne.asp"-->
<%
username=request.form("username")
passw=request.form("passw")
gender=request.form("gender")
birthday=request.form("birthday")
province=request.form("province")
city=request.form("city")
qq=request.form("qq")
email=request.form("email")
homepage=request.form("homepage")
signature=request.form("signature")
exec="insert into user(username,passw,gender,birthday,province,city,qq,email,homepage,signature)values('"+username+"','"+passw+"','"+gender+"','"+birthday+
<%set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("message_#book.asp")
%>
写入数据库文件代码：
<!--#include file="/data/conne.asp"-->
<%
username=request.form("username")
passw=request.form("passw")
gender=request.form("gender")
birthday=request.form("birthday")
province=request.form("province")
city=request.form("city")
qq=request.form("qq")
email=request.form("email")
homepage=request.form("homepage")
signature=request.form("signature")
exec="insert into user(username,passw,gender,birthday,province,city,qq,email,homepage,signature)values('"+username+"','"+passw+"','"+gender+"','"+birthday+
注意一下你QQ字段的类型，如果是“数字”类型就应该如下面这样写(注：最好把表名或字段用[]括起来，因为可能有些表名或字段用了关键字，如："user"这个名称可能就是关键字)
exec="insert into [user]([username],[passw],[gender],[birthday],[province],[city],[qq],[email],[homepage],[signature]) values('"+username+"','"+passw+"','"+gender+"','"+birthday+"','"+province+"','"+city+"',"+qq+",'"+email+"','"+homepage+"','"+signature+"')"
如果QQ字段是“文本”类型就应该如下面这样写
exec="insert into [user]([username],[passw],[gender],[birthday],[province],[city],[qq],[email],[homepage],[signature]) values('"+username+"','"+passw+"','"+gender+"','"+birthday+"','"+province+"','"+city+"','"+qq+"','"+email+"','"+homepage+"&#