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 56083 invoked from network); 14 Dec 2000 06:14:27 -0000
Received: from rdu26-36-102.nc.rr.com (HELO akira.webslingerZ.com)
 (66.26.36.102)
  by locus.apache.org with SMTP; 14 Dec 2000 06:14:27 -0000
Received: by akira.webslingerZ.com (Postfix, from userid 501)
	id A7D8213032; Thu, 14 Dec 2000 01:15:52 -0500 (EST)
Received: from localhost (localhost [127.0.0.1])
	by akira.webslingerZ.com (Postfix) with ESMTP id A521C60AB
	for <cocoon-users@xml.apache.org>; Thu, 14 Dec 2000 01:15:52 -0500 (EST)
Date: Thu, 14 Dec 2000 01:15:52 -0500 (EST)
From: Donald Ball <balld@webslingerZ.com>
X-Sender: <balld@localhost.localdomain>
To: <cocoon-users@xml.apache.org>
Subject: Re: <?xml-logicsheet ...?> and esql
In-Reply-To: <20001214000413.A1781@dt0b3n83.maine.rr.com>
Message-ID: <Pine.LNX.4.30.0012140115180.1209-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 Thu, 14 Dec 2000, Matthew Cordes wrote:

> That didn't seem to work, but this is my second logicsheet so I most
> likely am in error.
>
> my logicsheet:
>
> <?xml version="1.0"?>
> <xsl:stylesheet version="1.0"
> xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
> xmlns:xsp="http://www.apache.org/1999/XSP/Core"
> xmlns:esql="http://apache.org/cocoon/SQL/v2"
> xmlns:mine="http://mine.com/my-logicsheet"
> >
>
> <xsl:template match="mine:do-stuff">
>   <esql:execute-query>
>     <esql:query>
>       select name, description from some_table where some condition
>     </esql:query>
>
> 		<esql:results>
> 			<record>
> 				<name><esql:get-string column="name"/></name>
> 				<description><esql:get-string column="name"/></description>
> 			</record>
> 		</esql:results>
>
> 		<esql:error-results>
>
> 			<!-- BUG?: with the newest cvs version i get null pointer exceptions
> 				when i include the below -->
> 			<!--
> 				<message><esql:get-message/></message>
> 				<stack><esql:get-stacktrace/></stack>
> 			-->
> 		</esql:error-results>
>   </esql:execute-query>
> </xsl:template>
>
> <xsl:template match="@*|*|text()|processing-instruction()">
> <xsl:copy>
>   <xsl:apply-templates select="@*|*|text()|processing-instruction()"/>
> </xsl:copy>
> </xsl:template>
> </xsl:stylesheet>
>
>
> my page:
> ?xml version="1.0"?>
> <?cocoon-process type="xsp"?>
> <?xml-logicsheet href="logicsheet.xsl" type="text/xsl"?>
> <xsp:page language="java"
> 	xmlns:esql="http://apache.org/cocoon/SQL/v2"
> 	xmlns:mine="http://mine.com/my-logicsheet"
> 	xmlns:xsp="http://www.apache.org/1999/XSP/Core"
> >
>
> <page>
> 	<mine:do-stuff/>
> </page>
> </xsp:page>

look carefully at the esql sample. you don't have an esql:connection
element, for instance.

- donald