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]
