cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christian Haul <h...@dvs1.informatik.tu-darmstadt.de>
Subject Re: esql:query problem
Date Wed, 25 Jun 2003 15:38:26 GMT
On 25.Jun.2003 -- 10:32 AM, Tim Bachta wrote:
> My code now looks like this w/out the <user-results> tag:
> <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:parameter direction="in"
> type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}</esql:call
> >
> <esql:call-results>
> <esql:result><xsp:expr>(ResultSet)<esql:get-object column="1"
> from-call="true"/></xsp:expr></esql:result>

Sorry, I should have been more verbose, try:

 <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:parameter direction="in" type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}</esql:call>
  <esql:results>
    <esql:row-results>
      <test><esql:get-string column="1"/></test>
    </esql:row-results>
   </esql:results>
 </esql:execute-query>

(In addition, call-results does not apply when a result set is returned)

	Chris.
-- 
C h r i s t i a n       H a u l
haul@informatik.tu-darmstadt.de
    fingerprint: 99B0 1D9D 7919 644A 4837  7D73 FEF9 6856 335A 9E08

---------------------------------------------------------------------
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