Chris, That was it, thank you for the help. All of you that helped thank you.
Tim Bachta -----Original Message----- From: Christian Haul [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 10:56 AM To: [EMAIL PROTECTED] Subject: Re: esql:query problem On 25.Jun.2003 -- 10:48 AM, Tim Bachta wrote: > Well I tried that and no error, the only problem is I get no results > either. I was looking at the example that I am working from Maybe you need to add the needs-query attribute. Some drivers don't like it if a CallableStatement is just execute()'ed and your java code uses executeQuery(). So, try <esql:execute-query> <esql:call needs-query="true">{call rptLocationDeviations( <esql:parameter direction="in"type="Int"><xsp:expr>number</xsp:expr></esql:parameter>, <esql:parameter direction="in" type="String"><xsp:expr>room</xsp:expr></esql:parameter>, <esql:parameter direction="in" type="String"><xsp:expr>beginTime</xsp:expr></esql:parameter>, <esql:parameter direction="in" type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)} </esql:call> <esql:results> <esql:row-results> <test><esql:get-string column="1"/></test> </esql:row-results> </esql:results> </esql:execute-query> > http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup > port > And it uses the call-results tag as well as the use-results tag. I > guess this may be bad documentation? I don't know I just wish I could > get this to work. Thanks again for the help it is really appreciated. This topic is difficult because each and every driver bahaves differently in this respect. But documentation is indeed slim. Please feel free to add to http://wiki.cocoondev.org Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- 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]
