I wish I could make the stored procedure easier, but unfortunately this is the procedure that I have been given.
Tim Bachta -----Original Message----- From: Scherler, Thorsten [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 12:07 PM To: [EMAIL PROTECTED] Subject: RE: esql !!!HELP!!! Hello Tim, your code is quite complex. I had heaps of problem with similar code. Can you break it down to 1 or 2 parameter? Your error: Line 702, column 45: ')' expected Line 707, column 65: ';' expected Line 710, column 6: illegal start of expression Line 702, column -1: inconvertible types Seeing the last error I reckon that MS SQL have a different type of data then you expect. -----Original Message----- From: Tim Bachta [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 6:54 PM To: [EMAIL PROTECTED] Subject: esql !!!HELP!!! Ok, I am using the syntax exactly like that of the example at http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Sup port <http://cocoon.apache.org/2.1/userdocs/xsp/esql.html#Stored+Procedure+Su pport> and I am getting errors. I am really confused on why I am getting these errors. Here is the code for the xsp that has the stored procedure in it: <esql:execute-query> <esql: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:para meter direction="in" type="String"><xsp:expr>endTime</xsp:expr></esql:parameter>)} </esql:call> <esql:call-results> <esql:use-results> <esql:result> <xsp:expr> <esql:get-object column="1" from-call="true"/> </xsp:expr> </esql:result> <esql:results> <esql:row-results> <test> <esql:get-string column="1"/> </test> </esql:row-results> </esql:results> </esql:use-results> </esql:call-results> </esql:execute-query> and the error message that I am getting is: The org.apache.cocoon.www.sitemap_xmap notifies that org.apache.cocoon.ProcessingException says: Language Exception More precisely: org.apache.cocoon.ProcessingException: Language Exception: org.apache.cocoon.components.language.LanguageException: Error compiling room_report_xsp: Line 702, column 45: ')' expected Line 707, column 65: ';' expected Line 710, column 6: illegal start of expression Line 702, column -1: inconvertible types Line 0, column 0: 4 errors Please any help is greatly appreciated. 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]
