look at: esql:get-xml
--- Michael Raffenberg <[EMAIL PROTECTED]> wrote: > Hi Tim, > > did you try the <esql:call> Tag? > Here you find a introduction: > http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Support > > --Raffy > > > -----Ursprüngliche Nachricht----- > > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Gesendet: Montag, 23. Juni 2003 22:55 > > An: [EMAIL PROTECTED] > > Betreff: esql:query problem > > > > > > I am attempting to call a stored procedure using esql:query. > > Other stored procedures work using this so it is not a > > connection issue. I have narrowed down the issue to being > > the procedure itself. I am selecting data and inserting it > > into a temp table then selecting more data and joining the > > two data sets. I need to use the temp tables there is no way > > around it. The problem is the stored procedure will not > > return a result set in cocoon because it sees the insert > > statement then stops thinking there is not a result set. My > > code from my xsp is below, if anyone has any information > > about why this does not work it would be greatly appreciated. > > Thank you > > > > > > > > > > > > Tim Bachta > > > > > > > > <esql:execute-query> > > > > <esql:query> > > > > execute a_joe > > '<xsp:expr>room</xsp:expr>','<xsp:expr>beginTime</xsp:expr>',' > > <xsp:expr> > > endTime</xsp:expr>' > > > > </esql:query> > > > > <esql:results> > > > > <task-dates> > > > > <esql:row-results> > > > > <task-date> > > > > <date> > > > > > > <esql:get-string column="1"/> > > > > </date> > > > > > > > > > > > > </task-date> > > > > > > > > </esql:row-results> > > > > </task-dates> > > > > </esql:results> > > > > > > > > </esql:execute-query> > > > > > > > > > > --------------------------------------------------------------------- > > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]