DO NOT REPLY [Bug 10054] -

[bugzilla]

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 [EMAIL PROTECTED]  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: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]