Insert

$PRINTER.println("********************************保存执行前事
件111****************************************");
var doc = getCurrentDocument();
var sql = "INSERT into `tlk_表单流
程`(APPLICATIONID,DOMAINID,id,item_cbo) VALUES(45,12,5,'fsdd')";
$PRINTER.println("********************************保存执行前事
件222*****"+sql+"***********************************");
insertByDSName("cesi",sql);



这样的插入语句 哪里错了吗  怎么不行。

请问报什么错。。

org.mozilla.javascript.EvaluatorException: unterminated string literal (Activity(11e0-cfac-a5dbe11e-88fb-c339751e48e8).Save.beforeActionScript#1)
at org.mozilla.javascript.DefaultErrorReporter.runtimeError(DefaultErrorReporter.java:109)
at org.mozilla.javascript.DefaultErrorReporter.error(DefaultErrorReporter.java:96)
at org.mozilla.javascript.Parser.addError(Parser.java:140)
at org.mozilla.javascript.TokenStream.getToken(TokenStream.java:518)
at org.mozilla.javascript.Parser.peekToken(Parser.java:166)
at org.mozilla.javascript.Parser.matchToken(Parser.java:210)
at org.mozilla.javascript.Parser.argumentList(Parser.java:1677)
at org.mozilla.javascript.Parser.memberExprTail(Parser.java:1817)
at org.mozilla.javascript.Parser.memberExpr(Parser.java:1732)
at org.mozilla.javascript.Parser.unaryExpr(Parser.java:1590)
at org.mozilla.javascript.Parser.mulExpr(Parser.java:1519)
at org.mozilla.javascript.Parser.addExpr(Parser.java:1500)
at org.mozilla.javascript.Parser.shiftExpr(Parser.java:1480)
at org.mozilla.javascript.Parser.relExpr(Parser.java:1454)
at org.mozilla.javascript.Parser.eqExpr(Parser.java:1410)
at org.mozilla.javascript.Parser.bitAndExpr(Parser.java:1399)
at org.mozilla.javascript.Parser.bitXorExpr(Parser.java:1388)
at org.mozilla.javascript.Parser.bitOrExpr(Parser.java:1377)
at org.mozilla.javascript.Parser.andExpr(Parser.java:1365)
at org.mozilla.javascript.Parser.orExpr(Parser.java:1353)
at org.mozilla.javascript.Parser.condExpr(Parser.java:1336)
at org.mozilla.javascript.Parser.assignExpr(Parser.java:1321)
at org.mozilla.javascript.Parser.expr(Parser.java:1308)
at org.mozilla.javascript.Parser.statementHelper(Parser.java:1161)
at org.mozilla.javascript.Parser.statement(Parser.java:655)
at org.mozilla.javascript.Parser.parse(Parser.java:377)
at org.mozilla.javascript.Parser.parse(Parser.java:315)
at org.mozilla.javascript.Context.compileImpl(Context.java:2320)
at org.mozilla.javascript.Context.compileString(Context.java:1348)
at org.mozilla.javascript.Context.compileString(Context.java:1337)
at cn.myapps.core.macro.runner.JavaScriptRunner.run(JavaScriptRunner.java:109)
at org.apache.jsp.portal.share.dynaform.activity.action_jsp._jspService(action_jsp.java:242)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:654)
at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:445)
at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:379)
at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:292)
at com.opensymphony.webwork.dispatcher.ServletDispatcherResult.doExecute(ServletDispatcherResult.java:114)
at cn.myapps.base.web.ServletResult.OBPMServletDispatcherResult.doExecute(OBPMServletDispatcherResult.java:32)
at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:101)
at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:312)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:207)
at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:137)
at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:81)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:115)
at com.opensymphony.xwork.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:81)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.webwork.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:171)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:151)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:31)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:100)
at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:189)
at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:113)
at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:233)
at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:198)
at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDispatcher.java:43)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:78)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiLanguageFilter.java:42)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:30)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:100)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:619)

你的sql语句有问题。`tlk_表单流
程`你打了中文符号。

var guest=getItemValueAsString("guest");
var tool=getItemValueAsString("tool");
var tool3=getItemValueAsString("tool3");
var process = getDocumentProcess();     
var formProcess = getFormProcess();
var subform = formProcess.doView("11e0-d2ab-1871daea-b391-ed60cd006084");//查询出表单*（11e0-d2ab-1871daea-b391-ed60cd006084）为表的fromid；       
var doc = process.doNew(subform,getWebUser(),createParamsTable());
doc.addStringItem("cbo",guest);       
doc.addStringItem("cbo2",tool);       
doc.addStringItem("cbo3",tool3);       
$PRINTER.println(guest+"=========g=="+guest+"=====333=============");
process.doCreate(doc);       

用这种方法就行了 11e0-d2ab-1871daea-b391-ed60cd006084为要插入表的fromID
("cbo2",tool) 前面为 数据库自动名称去掉item,后者为要插入的值