Hi Varga,
if you want to execute an own SQL-Statement you can
use getConnection tag with a scriptlet like
<db:getConnection id="dbcon"/>
<%
java.sql.Connection con = (java.sql.Connection)request.getAttribute("dbcon");
con.executeUpdate("update foo set ...");
%>
(must add checks for NullpointerExc., SQLExc. etc)
Regards
Dirk
> Varga Sandor wrote:
>
> 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.
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
