cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Frank Taffelt" <frank.taff...@interface-business.de>
Subject Re: Stored Procedure Help
Date Tue, 24 Jun 2003 16:16:37 GMT
try the following:



<esql:execute-query>
  <esql:call>
    {call rptLocationDeviations(<esql:parameter direction="in"
type="Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:parameter
direction="in"
type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:para
meter direction="in"
type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}
  </esql:call>
       <esql:results>
         <esql:row-results>
          <test>
           <!-- I'm not sure if this is correct,
              because param 1 is the returned resultset.
              use an explicit column name from your resultset
              instead -->
            <esql:get-string column="1"/>
          </test>
       </esql:row-results>
     </esql:results>
  </esql:execute-query>


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


Mime
View raw message