making queries

Scheduler Javascript
#1

this isnt work:

gridConn.sql.attach(OperationType.UPDATE,"Update tableA set name='{name}', price={price} where id={id}");
//...
gridConn.render_sql(" .. ","id","price,name");
#2

I need another version??

#3

What do you mean by “not work” ?

Does it not work for data loading or for data saving?
You can enable logs to get more info about saving process
docs.dhtmlx.com/doku.php?id=dhtm … ava:errors

#4

i want to say i cant do it. the code shows errors in: gridConn.sql.attach(OperationType.UPDATE,"Update tableA set name='{name}', price={price} where id={id}");

specyficly in gridConn.sql.attach!!, i use the scheduler

#5

Try to change code as

((DBDataWrapper)gridConn.sql).attach(....
#6

thanks so much, Ive defined my own query, now when i try to update i have this error:
04-ene-2013 9:57:54 org.apache.catalina.core.StandardWrapperValve invoke
GRAVE: Servlet.service() para servlet Scheduler_Database lanzó excepción
java.lang.NullPointerException
at CYTRUSS.Calendar.Consultas.connector.DataProcessor.get_post_values(DataProcessor.java:76)
at CYTRUSS.Calendar.Consultas.connector.DataProcessor.process(DataProcessor.java:105)
at CYTRUSS.Calendar.Consultas.connector.BaseConnector.render(BaseConnector.java:292)
at CYTRUSS.Calendar.Consultas.connector.BaseConnector.render_sql(BaseConnector.java:262)
at CYTRUSS.Calendar.Consultas.connector.BaseConnector.render_sql(BaseConnector.java:230)
at CYTRUSS.Calendar.Consultas.connector.Scheduler_Database.configure(Scheduler_Database.java:27)
at CYTRUSS.Calendar.Consultas.connector.ConnectorServlet.doGet(ConnectorServlet.java:33)
at CYTRUSS.Calendar.Consultas.connector.ConnectorServlet.doPost(ConnectorServlet.java:40)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
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.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(Unknown Source)

#7

this is my code

[code]scheduler.load(“http://192.168.1.103:8400/CYTRUSS_Calendar/Scheduler_Database?usr="+usr+"&cal=”+cal);
//scheduler.load(“events.do?uid=”+scheduler.uid());

	var dp = new dataProcessor("http://192.168.1.103:8400/CYTRUSS_Calendar/Scheduler_Database?usr="+usr+"&cal="+cal);
	dp.init(scheduler);[/code]

can i use another servlet??

#8

Please try to enable logging and send results for the problematic operation.
Js code looks valid, according to stack trace - server side code can’t parse incoming data, but I don’t see any real reason for such problem.

docs.dhtmlx.com/doku.php?id=dhtm … ava:errors