cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Donald Ball <>
Subject Re: SQL - stored procedures
Date Thu, 20 Jul 2000 21:30:01 GMT
On Thu, 20 Jul 2000, Erikjan Rijkers wrote:

> I noticed that using <query> with a (sybase) stored procedure, it returns a 
> result set, but only of the first encountered sql statement in that stored 
> procedure. Any subsequent selects are disregarded.
> It should really resolve all encountered queries using Statement's 
> getMoreResults() method, and return those.
> Is this being worked on by somebody? 
> If not I may look into it, because it would be quite handy for me.
> Didn't look the taglib behaviour yet. Maybe it is solved there?

nope, no one has ever done anything with stored procedures that return
multiple resultsets. it's your baby. shouldn't be too hard to patch the
logicsheet to iterate over multiple resultsets.

- donald

View raw message