RE: retrieve esql return code or output paramter

Naquin, Beth Wed, 26 Jun 2002 09:32:56 -0700

Title: RE: retrieve esql return code or output paramter

Thanks for the suggestion, but I am still having problems.

I tried:

<esql:execute-query>

        <esql:call>
        {call LaunchSearches(
         <esql:parameter direction="in" type="String"><xsp-request:get-parameter name="xlpin"/></esql:parameter>,2)}
      </esql:call>

        <esql:call-results>
                <output>hello!</output>
                <output>j<esql:get-int column="1" from-call="yes"/>s</output>
                <output>Hello2!</output>
        </esql:call-results>

</esql:execute-query>

But I end up with:

<output>hello!</output>
<output>j

                </output>
-------------------------------------

when I expected:

<output>hello!</output>
<output>j2s</output>
<output>Hello2!</output>
--------------------------------------

Not only do I not see the 0-4 return code, but everything after the <esql:get-int ...>line is 'gone.' I have also tried esql:get-string and have tried other column numbers column="2", column="0", but the results are the same.

Any ideas or suggestions would be appreciated.

Thanks,
Beth

-----Original Message-----
From: Christian Haul [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 25, 2002 11:48 PM
To: [EMAIL PROTECTED]
Subject: Re: retrieve esql return code or output paramter

On 25.Jun.2002 -- 03:08 PM, Naquin, Beth wrote:
> Hello,
>
> This is probably obvious, but I just haven't been able to figure it out.
>
> I have a stored procedure that returns a return code, but not a resultset.
> The return codes are 0-4 and each mean something specific.
> When I execute the stored procedure, I need to be able to retrieve the
> return code and use it in my xsl stylesheet.
>
> I can't figure out what to put inside <esql:call-results> to retrieve this
> return code.

Try <esql:get-int column="1" from-call="yes"/>

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

---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>

To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>

RE: retrieve esql return code or output paramter

Reply via email to