Return-Path: 
 <cocoon-users-return-52507-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 72759 invoked by uid 500); 24 Jun 2003 16:51:48 -0000
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Precedence: bulk
list-help: <mailto:cocoon-users-help@xml.apache.org>
list-unsubscribe: <mailto:cocoon-users-unsubscribe@xml.apache.org>
list-post: <mailto:cocoon-users@xml.apache.org>
Reply-To: cocoon-users@xml.apache.org
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 72737 invoked from network); 24 Jun 2003 16:51:47 -0000
Received: from 106.mui7.chcg.cgcil02r18.dsl.att.net (HELO
 kopentpdc.kopent.com) (12.134.7.106)
  by daedalus.apache.org with SMTP; 24 Jun 2003 16:51:47 -0000
content-class: urn:content-classes:message
Subject: esql !!!HELP!!!
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Date: Tue, 24 Jun 2003 11:53:57 -0500
X-MimeOLE: Produced By Microsoft Exchange V6.0.4417.0
Message-ID: <51FB159F7E0F3F45A90965F331DEAA870EAFB0@kopentpdc.kopent.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: esql !!!HELP!!!
Thread-Index: AcM6cIMuGdsYA/mOTtymfk7WLssayA==
From: "Tim Bachta" <tbachta@kopent.com>
To: <cocoon-users@xml.apache.org>
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

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>

            {? =3D rptLocationDeviations(<esql:parameter =
direction=3D"in"
type=3D"Int"><xsp:expr>number</xsp:expr></esql:parameter>,<esql:parameter=

direction=3D"in"
type=3D"String"><xsp:expr>room</xsp:expr></esql:parameter>,<esql:paramete=
r
direction=3D"in"
type=3D"String"><xsp:expr>beginTime</xsp:expr></esql:parameter>,<esql:par=
a
meter direction=3D"in"
type=3D"String"><xsp:expr>endTime</xsp:expr></esql:parameter>)}

            </esql:call>

            <esql:call-results>

                        <esql:use-results>

                                    <esql:result>

                                                <xsp:expr>

                                                <esql:get-object
column=3D"1" from-call=3D"true"/>

                                                </xsp:expr>

                                    </esql:result>

                                    <esql:results>

                                                <esql:row-results>

                                                            <test>

=20
<esql:get-string column=3D"1"/>

                                                            </test>

                                                </esql:row-results>

                                    </esql:results>

                        </esql:use-results>

            </esql:call-results>

</esql:execute-query>

=20

and the error message that I am getting is:

=20

The org.apache.cocoon.www.sitemap_xmap notifies that
org.apache.cocoon.ProcessingException says:

Language Exception=20

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:=20
4 errors

=20

Please any help is greatly appreciated.

=20

Tim Bachta

=20

=20


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-users-unsubscribe@xml.apache.org
For additional commands, e-mail: cocoon-users-help@xml.apache.org