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
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
