asp连接access数据库问题,急急急!!!
这是我的代码:
asp中接受从表单提交的数据:
<script language=vbscript>
<%
user = Request.form("user")
sex = Request.form("sex")
number = Request.form("number")
password = Request.form("password")
birthday = Request.form("birthday")
school = Request.form("school")
college = Request.form("college")
class_name = Request.form("class")
qq = Request.form("qq")
Email = Request.form("Email")
hobby = Request.form("hobby")
introduction = Request.form("introduction")
%>
<%
dim mysql
mysql="insert into student(name,sex,number,password,birthday,school,college,classes,QQ,email,hobby,introduction) values('"&user&"','"&sex&"','&number&','"&password&"','"&birthday&"','"&school&"','"&college&"','"&class_name&"','"&qq&"','"&Email&"','"&hobby&"','"&introduction&"')"
conn.Execute("insert into student(name,sex,number,password,birthday,school,college,class,QQ,email,hobby,introduction) values('"&user&"','"&sex&"','"&number&"','"&password&"','"&birthday&"','"&school&"','"&college&"','"&class_name&"','"&qq&"','"&Email&"','"&hobby&"','"&introduction&"')")
%>
其中number,QQ,birthday在access中是数字型和日期时间型,总是提示“Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/On-line Course/submission.asp, 第 33 行
”
各位知道的请赐教,急需解答!