cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 10054] - <esql:update-results>
Date Mon, 19 Aug 2002 14:24:50 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10054>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=10054

<esql:update-results>





------- Additional Comments From pescetelli@ksolutions.it  2002-08-19 14:24 -------
I've set the <esql:allow-multiple-results> but nothing is changed.
My setting is:

dbms: Oracle 8.1.7
jdbc: 2.0 (I'm using the jdbc delivered with oracle) but nothing changes 
with 1.0
jdk: 1.4 (build 1.4.0-b92)
tomcat: 4.0.4
cocoon: 2.1(dev)...this could be the reason (I guess?)
I've checked out my cocoon version the 27/June.
I'll check with a different cocoon version, anyway my XSP is:

<?xml version="1.0" encoding="ISO-8859-1"?>

<xsp:page
  language="java" 
  xmlns:xsp="http://apache.org/xsp"
  xmlns:esql="http://apache.org/cocoon/SQL/v2">

  <root>
    <esql:connection>
      <esql:allow-multiple-results>true</esql:allow-multiple-results>
      <esql:pool>MSiteDB</esql:pool>
      <esql:execute-query>

<!-- UPDATE 
-->
        <esql:query>
          update assets_tb set asset_id=(asset_id+1)
        </esql:query>
        <esql:error-results>An error occurred</esql:error-results>
        <esql:update-results>
           <esql:get-update-count/> rows  adjusted.
        </esql:update-results>
        <esql:no-results>
           <p>Sorry, no rows adjusted!</p>
        </esql:no-results>

      </esql:execute-query>
    </esql:connection>
  </root>
</xsp:page>

---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org


Mime
View raw message