Return-Path: 
 <cocoon-users-return-41715-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 29728 invoked by uid 500); 25 Oct 2002 10:38:57 -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 29714 invoked from network); 25 Oct 2002 10:38:55 -0000
Date: Fri, 25 Oct 2002 13:38:44 +0300 (EEST)
Sender: Tuomo Henrikki Lesonen <tuomo@niksula.hut.fi>
From: Tuomo Lesonen <tuomo@niksula.hut.fi>
To: cocoon-users@xml.apache.org
Subject: Re: [PATCH] for <xsp-session:getxml>
In-Reply-To: <5.1.1.6.0.20021025115815.04b737b0@mail.visitronics.be>
Message-ID: <Pine.GSO.4.44.0210251337380.20796-100000@kekkonen.cs.hut.fi>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=ISO-8859-1
Content-Transfer-Encoding: 8BIT
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi Bert,

Try to put <esql:parameter> around <xsp-sessio:getxml> in your query.

-Tuomo


On Fri, 25 Oct 2002, Bert Van Kets wrote:

> Hi Antonio,
> I've been trying hard to get this esql sample to work.
> The tag works perfectly.
>      <user><xsp-session:getxml context="authentication"
> path="/authentication/ID"/></user>
> returns the userID in my xsp page.  So there is nothing wrong with the
> class or the session.xsl file.
>
> However, I need to create a query containing the userID.  I think I went
> through the whole book of exceptions in Cocoon. :-(
> When I try it the way you describe below, I get an error saying "method
> parseInt() not found in class java.lang.Integer".  I guess this means
> 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=<xsp-session:getxml
> context="authentication" path="/authentication/ID" as="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 =
> >   <esql:parameter type="int">
> >     <xsp:expr>
> >       Integer.parseInt(
> >         <xsp-session:getxml context="authentication"
> > path="/authentication/ID"
> >as="string"/>)
> >     </xsp:expr>
> >   </esql:parameter>
> ></esql:query>
> >
> >Antonio Gallardo
> >
> >El Martes, 08 de Octubre de 2002 05:43, Antonio Gallardo Rivera escribi�:
> > > Hi, I recently needed to write some app logi usin <xsp:logic> tags. Into
> > > tags we need to write some code like:
> > >
> > > String myUserID = <xsp-session:getxml context="authentication"
> > > path="/authentication/ID" as="string"/>;
> > >
> > > Then, I updated <xsp-session:getxml> to serve strings.
> > >
> > > Currently the attribute "as" of the element can have 3 values:
> > >
> > > 1-as="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="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="authentication" path="/authentication/ID"
> > > as="string"/>
> > >
> > > will return "MyID"
> > >
> > > B) <xsp-session:getxml context="authentication"
> > > path="/authentication/data/fullname" as="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>
>


---------------------------------------------------------------------
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>