Thanks to everyone for their help.
From: Christian Haul <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Re: Cocoon + postgreSQL Date: Mon, 05 Jan 2004 14:25:38 +0100
Tommy Smith wrote:
Thank you and Luca for your replies.
I'm getting closer to what I want now.
My problem now is processing the resultset from my stored procedure.
<esql:call><snip/><esql:call-results> <esql:row-results> <esql:get-columns/>
This works *only* if the driver will return a resultset with the call which is unlikely. Usually, the resultset is returned as out parameter which can then be casted to a resultset object.
From the docs:
| If a result set is returned through the (only) return parameter of a | stored procedure, e.g. resultset-from-object="1" as attribute to | <esql:call/>to automatically use this result set. For a more general | alternative see further below.
| <esql:call>{? = foo(<esql:parameter direction="in" | type="Int"><xsp:expr>1</xsp:expr></esql:parameter>)} | </esql:call> | <esql:call-results> | <esql:use-results> | <esql:result><xsp:expr>(ResultSet)<esql:get-object column="1" | from-call="true"/></xsp:expr></esql:result> | <esql:results> | <esql:row-results> | <esql:get-string column="1"/> | </esql:row-results> | </esql:results> | </esql:use-results> | </esql:call-results>
HTH Chris.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
_________________________________________________________________
Use MSN Messenger to send music and pics to your friends http://www.msn.co.uk/messenger
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
