esql !!!HELP!!!

[Tim Bachta <tb...@kopent.com>]

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: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org