On 05.Sep.2003 -- 02:11 PM, Martin Rusnak wrote: > Here is full source of the page: > > <?xml version="1.0"?> > <xsp:page language="java" > xmlns:xsp="http://apache.org/xsp"; > xmlns:esql="http://apache.org/cocoon/SQL/v2";> > <rowset> > <esql:connection> > <esql:pool>oracle-connection</esql:pool> > <esql:execute-query> > <esql:call resultset-from-object="1">{?=call sp_test()}</esql:call> > <esql:call-results> > <esql:row-results> > <row> > <esql:get-columns/> > </row> > </esql:row-results> > </esql:call-results> > </esql:execute-query> > </esql:connection> > </rowset> > </xsp:page>
Processing of @resultset-from-object has been broken. I've updated CVS just now. Please update and verify. Anyway, you will still need to enclose the result with esql:results. Apart from that, you may use <esql:call>....</esql:call> <esql:call-results> <esql:use-result> <esql:result><xsp:expr>(ResultSet)<esql:get-object from-call="true" column="1"/><xsp:expr></esql:result> <esql:results> ... </esql:results> </esql:use-result> </esql:call-results> Which is a little more verbose but IMHO preferable to the @resultset-from-object syntax. see http://cocoon.apache.org/2.1/userdocs/xsp/esql.html 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]
