#12002/10/31 14:02:12
数据库用的ACCESS
CFMX
insert.cfm是个表单
reslut.cfm的内容
结果说我insert语法错
怎么回事呢
我换成用cfquery语句来insert也一样的结果
出错语句为
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
The error occurred in C:\CFusionMX\wwwroot\WorkReport\result.cfm: line 19
17 :
18 :
19 :
--------------------------------------------------------------------------------
SQL
insert into report (UNDERTAKER,TIME,CONTENT,PLACE,USERNAME,SNAME,DATE,PNAME) values ( (param 1) , (param 2) , (param 3) , (param 4) , (param 5) , (param 6) , (param 7) , (param 8) )
DATASOURCE WorkReport
VENDORERRORCODE -3502
SQLSTATE 42000
各位帮忙,谢谢!