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]
