Hi, try it with <esql:call> Here is a fast example:
<esql:execute-query> <esql:call>{call pip2a9.HiQuery ('', '', '', '583911','<xsp:expr>class_id</xsp:expr>','true','<xsp:expr>sl</xsp:expr>', '','<xsp:expr>pl</xsp:expr>','<xsp:expr>ps</xsp:expr>',<esql:parameter direction="out" type="String"/>)} </esql:call> <esql:call-results> <response> <esql:execute-query> <esql:query> <esql:get-string ancestor="1" from-call="true" column="1"/> </esql:query> <esql:skip-rows><xsl:value-of select="$skiprows"/></esql:skip-rows> <esql:max-rows><xsl:value-of select="$maxrows"/></esql:max-rows> <esql:results> <status><s.success/></status> <part.info> <esql:row-results> <element> <esql:get-columns/> </element> </esql:row-results> </part.info> </esql:results> <esql:no-results> <status><s.nomatch/></status> </esql:no-results> </esql:execute-query> </response> </esql:call-results> <esql:error-results> <message><esql:get-message/></message> <stacktrace><esql:get-stacktrace/></stacktrace> </esql:error-results> </esql:execute-query> Hope that can help. --Michael > > > Here is the code from the page: > <?xml version="1.0" encoding="UTF-8"?> > <xsp:page language="java" xmlns:xsp="http://apache.org/xsp" > xmlns:xsp-request="http://apache.org/xsp/request/2.0" > xmlns:esql="http://apache.org/cocoon/SQL/v2" > xmlns:xsp-session="http://apache.org/xsp/session/2.0" > create-session="true"> > <page> > <xsp:logic> > String beginTime ="5-20-2003"; > String endTime = "6-20-2003"; > String room = "Rm 130 B"; > String qry = "rptLocationDeviationsgetTasks 'Rm 130 > B','5-20-2003','6-20-2003'"; > </xsp:logic> > <title>Room Report for <xsp:expr>room</xsp:expr> > <xsp:expr>beginTime</xsp:expr> to > <xsp:expr>endTime</xsp:expr></title> > <content> > <esql:connection> > <esql:pool>vyzo</esql:pool> > <esql:execute-query> > <esql:query> > execute > rptLocationDeviationsgetTasks > '<xsp:expr>room</xsp:expr>','<xsp:expr>beginTime</xsp:expr>',' > <xsp:expr> > endTime</xsp:expr>' > </esql:query> > <esql:results> > <tasks> > > <esql:row-results> > <task> > > <name> > > <esql:get-string column="2"/> > > </name> > </task> > > </esql:row-results> > </tasks> > </esql:results> > </esql:execute-query> > > <esql:execute-query> > <esql:query> > execute > rptLocationDeviations > '<xsp:expr>room</xsp:expr>','<xsp:expr>beginTime</xsp:expr>',' > <xsp:expr> > endTime</xsp:expr>' > </esql:query> > <esql:results> > <task-date> > > <esql:row-results> > <task> > > <task-name> > > <esql:get-string column="2"/> > > </task-name> > </task> > > </esql:row-results> > </task-date> > </esql:results> > </esql:execute-query> > </esql:connection> > </content> > </page> > </xsp:page> > > and this is the output that I am getting: > > <?xml version="1.0" encoding="UTF-8" ?> > - <page xmlns:xsp-session="http://apache.org/xsp/session/2.0" > xmlns:xsp="http://apache.org/xsp" > xmlns:xspdoc="http://apache.org/cocoon/XSPDoc/v1" > xmlns:esql="http://apache.org/cocoon/SQL/v2" > xmlns:xsp-request="http://apache.org/xsp/request/2.0"> > <title>Room Report for Rm 130 B 5-20-2003 to 6-20-2003</title> > - <content> > - <tasks> > - <task> > <name>Change Bottles</name> > </task> > - <task> > <name>Check Room</name> > </task> > - <task> > <name>Special Feed</name> > </task> > - <task> > <name>Special Water</name> > </task> > - <task> > <name>Cages/Feed/H20/Mop</name> > </task> > </tasks> > </content> > </page> > > Tim Bachta > > > > -----Original Message----- > From: Tim Bachta > Sent: Thursday, June 19, 2003 11:57 AM > To: [EMAIL PROTECTED] > Subject: No results from a stored procedure > > Is there a reason why cocoon would not execute a certain > stored procedure? I have one that I have verified returns a > result set but when I run it in cocoon I am not getting > anything back. It looks like it is skipping over the section > completely. > > > > Tim Bachta > > > > > > > --------------------------------------------------------------------- > 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]