Well I tried that and no error, the only problem is I get no results either. I was looking at the example that I am working from http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup port And it uses the call-results tag as well as the use-results tag. I guess this may be bad documentation? I don't know I just wish I could get this to work. Thanks again for the help it is really appreciated.
Tim Bachta -----Original Message----- From: Christian Haul [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 10:38 AM To: [EMAIL PROTECTED] Subject: Re: esql:query problem 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
