Return-Path: <balld@webslingerZ.com>
Mailing-List: contact cocoon-users-help@xml.apache.org; run by ezmlm
Delivered-To: mailing list cocoon-users@xml.apache.org
Received: (qmail 94802 invoked from network); 17 Oct 2000 18:28:36 -0000
Received: from ma29.webslingerz.com (HELO ma7.webslingerZ.com) (216.27.73.29)
  by locus.apache.org with SMTP; 17 Oct 2000 18:28:36 -0000
Received: by ma7.webslingerZ.com (Postfix, from userid 501)
	id CF3AC480F; Tue, 17 Oct 2000 14:30:48 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
	by ma7.webslingerZ.com (Postfix) with ESMTP
	id 6D3DE6087; Tue, 17 Oct 2000 14:30:48 -0400 (EDT)
Date: Tue, 17 Oct 2000 14:30:48 -0400 (EDT)
From: Donald Ball <balld@webslingerZ.com>
X-Sender: balld@localhost.localdomain
To: cocoon-users@xml.apache.org
Cc: mohamed ramzy <m_ramzy@yahoo.com>
Subject: Re: ESQL in stylesheet question
In-Reply-To: <a05001908b61247cbecbb@[10.0.1.2]>
Message-ID: <Pine.LNX.4.21.0010171430010.3140-100000@localhost.localdomain>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N

On Tue, 17 Oct 2000, Chris Meyer wrote:

> I'm trying to use ESQL in a stylesheet defined similar to the following:
> 
> <?xml version="1.0"?>
> 
> <xsl:stylesheet version="1.0"
>    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
>    xmlns:esql="http://apache.org/cocoon/SQL/v2"
>    xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>    xmlns:myss="http://someurl.com/myss"
> >
> 
> 
> <xsl:template match="myss:query">
>      <esql:execute-query>
>        ... driver, url, username, password, query, etc. clipped out ...
>      </esql:execute-query>
> </xsl:template>
> 
> <xsl:template match="xsp:page">
>    <xsp:page>
>      <xsl:apply-templates select="@*"/>
>      <xsl:apply-templates/>
>    </xsp:page>
> </xsl:template>
> 
> <xsl:template match="@*|*|text()|processing-instruction(  )">
>    <xsl:copy>
>      <xsl:apply-templates select="@*|*|text()|processing-instruction(  )"/>
>    </xsl:copy>
> </xsl:template>
> 
> </xsl:stylesheet>
> 
> 
> 
> I also have an .xml page like:
> 
> <?xml version="1.0"?>
> <?xml-stylesheet href="index.xsl" type="text/xsl"?>
> <?cocoon-process type="xsp"?>
> <!-- <?cocoon-process type="xslt"?> -->
> 
> <xsp:page
>    language="java"
>    xmlns:xsp="http://www.apache.org/1999/XSP/Core"
>    xmlns:request="http://www.apache.org/1999/XSP/Request"
>    xmlns:myss="http://someurl.com/myss"
> >
> 
> <data>
>    <myss:query/>
> </data>
> 
> </xsp:page>
> 
> 
> When I load this in my browser, all I get is the text of the driver, 
> the username, password, query, etc.
> 
> This is similar to other people's problems (mohamed ramzy) but I 
> haven't seen an answer that helps me.
> 
> I'm sure its something trivial -- anyone have any ideas?

you need to declare the esql namespace in your xml file. yes, it's stupid,
but it's necessary in c1. alternately, you could put a xml-logicsheet PI
in your xml file.

- donald