Return-Path: 
 <cocoon-users-return-31319-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 56258 invoked by uid 500); 4 Apr 2002 12:50:08 -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 56247 invoked from network); 4 Apr 2002 12:50:08 -0000
From: "Vadim Gritsenko" <vadim.gritsenko@verizon.net>
To: <cocoon-users@xml.apache.org>
Subject: RE: esql & transformations
Date: Thu, 4 Apr 2002 07:50:40 -0500
Message-ID: <004001c1dbd7$53a490b0$0a00a8c0@vgritsenkopc>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="US-ASCII"
Content-Transfer-Encoding: 7bit
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook, Build 10.0.2616
X-Mimeole: Produced By Microsoft MimeOLE V6.00.2600.0000
In-Reply-To: <006501c1dbb7$107f4980$1100000a@plaszczak>
Importance: Normal
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

See http://localhost:8080/cocoon/sub/xsl-cocoon sample. It does
generates XSL using XSP.

Vadim

> From: Jerzy Kut [mailto:jerzyk@rzeszow.tiger.com.pl]
> 
> Hi all!
> Can I use esql in transformation file? How?
> I try:
> 
> employees-xsp.xsl
> 
> <?xml version="1.0"?>
> <xsl:stylesheet version="1.0"
>                 xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>                 xmlns:xsp="http://apache.org/xsp"
>                 xmlns:esql="http://apache.org/cocoon/SQL/v2">
> 
>  <xsl:template match="employees">
>  <esql:connection>
>   <esql:pool>epayroll</esql:pool>
>   <esql:execute-query>
>    <esql:query>
>     select E1.EMPNO, E1.ENAME, E1.JOB, E2.EMPNO MGRNO, E2.ENAME MGR,
> E1.HIREDATE, E1.SAL, E1.COMM, D.DEPTNO, D.DNAME
>     from EMP E1, EMP E2, DEPT D
>     where E1.DEPTNO = D.DEPTNO
>     and E1.MGR = E2.EMPNO (+)
>    </esql:query>
>    <esql:results>
>     <esql:row-results>
>      <employee>
>       <id><esql:get-long column="EMPNO"/></id>
>       <name><esql:get-string column="ENAME"/></name>
>       <job><esql:get-string column="JOB"/></job>
>       <hiredate><esql:get-date column="HIREDATE"/></hiredate>
>       <manager-name><esql:get-string column="MGR"/></manager-name>
>       <manager-id><esql:get-long column="MGRNO"/></manager-id>
>       <salary><esql:get-double column="SAL"/></salary>
>       <comm><esql:get-string column="COMM"/></comm>
>       <department-id><esql:get-long column="DEPTNO"/></department-id>
>       <department-name><esql:get-string
column="DNAME"/></department-name>
>      </employee>
>     </esql:row-results>
>    </esql:results>
>    <esql:no-results>
>     <employee-lack>
>      <message>No data!</message>
>     </employee-lack>
>    </esql:no-results>
>   </esql:execute-query>
>  </esql:connection>
>  </xsl:template>
> 
>  <xsl:template match="node()|@*">
>   <xsl:copy>
>    <xsl:apply-templates select="node()|@*"/>
>   </xsl:copy>
>  </xsl:template>
> 
> </xsl:stylesheet>
> 
> sitemap.xmap
> 
>    <map:match pattern="main">
>     <map:aggregate element="main">
>      <map:part src="docs/description.xml"/>
>      <map:part src="docs/manager.xml"/>
>     </map:aggregate>
>     <map:transform src="stylesheets/employees-xsp.xsl"/>
>     <map:serialize type="xml"/>
>    </map:match>
> 
> but unfortunatelly it doesn't work.
> Help please (cocoon2.0.2).
> 
> Best regards
> 
> Jerzy Kut


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

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