错在哪里了?ACCESS 中 INSERIT INTO语法问题
代码如下:
<%
set conn=server.createobject( "adodb.connection ")
conn.open "driver={microsoft access driver (*.mdb)};dbq= "&server.mappath( "gustb.mdb ")
id=request.form( "aid ")
ccase=request.form( "acase ")
starttime=request.form( "astime ")
overtime=request.form( "aotime ")
reason=request.form( "areason ")
worker= request.form( "aworker ")
exec= "insert into beian([id],[ccase],[strattime],[overtime],[reason],[worker])values( "+aid+ ", ' "+acase+ " ', ' "+astime+ " ', ' "+aotime+ " ', ' "+areason+ " ', ' "+aworker+ " ') "
conn.execute exec
rs.open exec,conn,1,3
conn.close
set conn=nothing
response.write "记录添加成功! "
%>
<%
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
错误类型：
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/tj.asp, 第 11 行
[解决办法]
如果strattime,overtime 是日期类型 要用#
# "&astime& "#,# "&aotime& "#
