Hello!!! I'm trying to update form data, using on-value-changed:
<fd:field id="density" required="true">
<fd:label>Плотность</fd:label>
<fd:datatype base="decimal"/>
<fd:on-value-changed>
<javascript>
var value = this.value;
var test =
cocoon.parameters["comp_id"];
var sql = "update
compositions set density = " + value + " where id = " + test;
dao.dbi.execute(sql);
</javascript>
</fd:on-value-changed>
</fd:field>
But as output I've got the exception:
java.sql.SQLException: ORA-00904: "UNDEFINED": invalid identifier
What's the problem ?