Hello All !
Happy New Year !
 
I also have a question. How can I execute an UPDATE SQL statement? Or any else complicated - but not only select - statement?
The documentation says the queryData tag can execute any SQL statement accepted by the database, but using the following:
 
<db:checkbox fieldName="valoare">
  <db:queryData name="AnyName" query="update docdet set valoare=111"/>
</db:checkbox>
 
and I have the following error:
 
Database error in EmbeddedData.fetchData java.sql.SQLException: Can not issue INSERT/UPDATE/DELETE with executeQuery()
 
There are situations when the complex SQL statements are needed.
Thanks for your help.
Varga Sandor.

Reply via email to