<%option explicit%>
<%response.buffer=true%>
<!--#include file="connection.asp"-->
<%
dim one,two,three,four,five,six,seven
one=request.form("name")
two=request.form("sex")
three=request.form("oicq")
four=request.form("email")
five=request.form("zhuye")
six=request.form("liuyan")
seven=now()
dim c,d
c="insert into liuyanbo(name,sex,oicq,email,liuyan,time"
d="values('"&one&"','"&two&"','"&three&"','"&four&"','"&six&"','"&seven&"'"
if five<>"" then
c=c&",zhuye"
d=d&",'"&five&"'"
end if
c=c&")"&d&")"
cn1.execute(c)
cn1.close
response.redirect"index.asp"
%>
比如时间和空格我都已经加进去了。
我已经根据你的提示改正了错误,但是
系统提示错误类型:
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/3/liuyanbo/add.asp, 第 21 行