Return-Path: 
 <cocoon-users-return-41711-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 15156 invoked by uid 500); 25 Oct 2002 10:10:03 -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 15134 invoked from network); 25 Oct 2002 10:10:01 -0000
Message-Id: <5.1.1.6.0.20021025115815.04b737b0@mail.visitronics.be>
X-Sender: postmaster.vankets@mail.visitronics.be
X-Mailer: QUALCOMM Windows Eudora Version 5.1.1
Date: Fri, 25 Oct 2002 12:06:26 +0200
To: cocoon-users@xml.apache.org
From: Bert Van Kets <bert@vankets.com>
Subject: Re: [PATCH] for <xsp-session:getxml>
In-Reply-To: <200210080554.36862.agallardo@agsoftware.dnsalias.com>
References: <200210080543.36799.agallardo@agsoftware.dnsalias.com>
 <200210080543.36799.agallardo@agsoftware.dnsalias.com>
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"; format=flowed
Content-Transfer-Encoding: quoted-printable
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi Antonio,
I've been trying hard to get this esql sample to work.
The tag works perfectly.
     <user><xsp-session:getxml context=3D"authentication"=20
path=3D"/authentication/ID"/></user>
returns the userID in my xsp page.  So there is nothing wrong with the=20
class or the session.xsl file.

However, I need to create a query containing the userID.  I think I went=20
through the whole book of exceptions in Cocoon. :-(
When I try it the way you describe below, I get an error saying "method=20
parseInt() not found in class java.lang.Integer".  I guess this means=20
nothing is returned and the parseInt can't convert.
I've tried all kind of combinations and always get an error.
Here's what I've got now (doesn't work of course):

       <esql:execute-query>
         <esql:query>SELECT * FROM members WHERE ID=3D<xsp-session:getxml=20
context=3D"authentication" path=3D"/authentication/ID"=
 as=3D"string"/></esql:query>
         <esql:results>
           <esql:row-results>
             <esql:get-columns/>
           </esql:row-results>
         </esql:results>
       </esql:execute-query>

What am I missing here????


Bert

P.S. Using Cocoon 2.1 build of 14 May 2002, Tomcat 4.0.1, JDK 1.3.1_2


At 05:54 8/10/2002 -0600, you wrote:
>Another usage of this tag is to set the parameters of a query based on the=
 is
>in <esql:query> see the example:
>
><esql:query>
>   SELECT usr_name, usr_full_name, usr_password FROM users
>   WHERE usr_id =3D
>   <esql:parameter type=3D"int">
>     <xsp:expr>
>       Integer.parseInt(
>         <xsp-session:getxml context=3D"authentication"=20
> path=3D"/authentication/ID"
>as=3D"string"/>)
>     </xsp:expr>
>   </esql:parameter>
></esql:query>
>
>Antonio Gallardo
>
>El Martes, 08 de Octubre de 2002 05:43, Antonio Gallardo Rivera escribi=F3:
> > Hi, I recently needed to write some app logi usin <xsp:logic> tags. Into
> > tags we need to write some code like:
> >
> > String myUserID =3D <xsp-session:getxml context=3D"authentication"
> > path=3D"/authentication/ID" as=3D"string"/>;
> >
> > Then, I updated <xsp-session:getxml> to serve strings.
> >
> > Currently the attribute "as" of the element can have 3 values:
> >
> > 1-as=3D"object" (default) returns a org.w3c.dom.DocumentFragment object.=
 More
> > info at
> >=
 http://xml.apache.org/xerces2-j/javadocs/api/org/w3c/dom/DocumentFragment.h
> >tml
> >
> > 2-as=3D"xml" return the DocumentFragment into <xsp-session:xml> tags.
> >
> > 3- return the value of the firstchild of the requested node. Example: If=
 we
> > have:
> >
> > <ID>MyID</ID>
> > <role>MyRole</role>
> > <data>
> > <fullname>TheFullName</fullname>
> >
> > A) Then if we write:
> > <xsp-session:getxml context=3D"authentication" path=3D"/authentication/I=
D"
> > as=3D"string"/>
> >
> > will return "MyID"
> >
> > B) <xsp-session:getxml context=3D"authentication"
> > path=3D"/authentication/data/fullname" as=3D"string"/>
> >
> > will return: "TheFullName"
> >
> > Attached is the new session.xsl the place of this file is:
> >
> >=
 xml-cocoon2/src/java/org/apache/cocoon/components/language/markup/xsp/java
> >
> > Antonio Gallardo
>
>---------------------------------------------------------------------
>Please check that your question  has not already been answered in the
>FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>
>
>To unsubscribe, e-mail:     <cocoon-users-unsubscribe@xml.apache.org>
>For additional commands, e-mail:   <cocoon-users-help@xml.apache.org>


---------------------------------------------------------------------
Please check that your question  has not already been answered in the
FAQ before posting.     <http://xml.apache.org/cocoon/faq/index.html>

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