这是我的代码:
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 行
”
各位知道的请赐教,急需解答!
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 行
”
各位知道的请赐教,急需解答!
解决方案 »
- 请教DataList里取不到TextBox的值
- 自定义SoapHeader
- 如何解决在ASP.NET中在登录得时候怎样控制不让同一个用户同时登录多次
- 一个页面里一个button,一个textbox,点了button,出了一个alert消息,确定后会把textbox里的值自动清空,怎么办
- 如何在TreeView中设置节点之间的间距?
- 求vb开发的web插件源码及调用的web页面
- 还有多少人用Editplus写程序而不用Visual Stidio.net?
- js 获取选中节点的Text,高手帮忙
- 有人用FreeTextBox 1.6.3 吗?
- 用js编写计算绑定的两列之差的方法
- 搜索问题。请解答
- “/”应用程序中的服务器错误。
-------------------------------insert 语句有问题啊。 你把number,QQ,birthday 全部用 string类型去搞。没必要用数字和日期。
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&"')")替换成:
conn.Execute(mysql)然后在此处打一断点,得到sql语句 ,放到查询分析器中执行一下对于dateTime类型的,确认参数有值且数据库内有默认值或允许为空