#12002/12/6 14:33:57
<%
name=Server.HtmlEncode(Request.form("name"))
dj=Server.HtmlEncode(Request.form("dj"))
qq=Server.HtmlEncode(Request.form("qq"))
email=Server.HtmlEncode(Request.form("email"))
Set conn=Server.CreateObject("ADODB.CONNECTION")
Set rs=Server.CreateObject("ADODB.RecordSet")
conn.open Application("reg")
conn.execute("insert into reg(time,name,dj,qq,email) values
(now(),'"&name&"','"&dj&"','"&qq&"','"&email&"')
")
rs.close
conn.close
set rs=nothing
set conn=nothing
%>
为什么总提示:
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access 驱动程序] INSERT INTO 语句的语法错误。
去掉time值之后,就正常, 时间格式now()不对么?还是表格time的数据类型不对啊?帮帮忙!3Qtimenow()