Return-Path: 
 <cocoon-users-return-44889-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 3121 invoked by uid 500); 16 Jan 2003 12:32:39 -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 3110 invoked from network); 16 Jan 2003 12:32:39 -0000
From: "Carsten Ziegeler" <cziegeler@s-und-n.de>
To: <cocoon-users@xml.apache.org>
Subject: RE: SQL Transformer substitute-value woes with 2.0.4
Date: Thu, 16 Jan 2003 13:32:38 +0100
Message-ID: <LKENJPKDAIKAPKHEOCMMMEFLCFAA.cziegeler@s-und-n.de>
MIME-Version: 1.0
X-Priority: 3 (Normal)
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook IMO, Build 9.0.6604 (9.0.2911.0)
In-Reply-To: <Pine.LNX.4.51.0301161212180.1062@oxygen.internal.luminas.co.uk>
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Importance: Normal
X-MIMETrack: Itemize by SMTP Server on PBSN1/Systeme und Netzwerke(Release
 5.0.8 |June
 18, 2001) at 16.01.2003 13:32:36,
	Serialize by Router on PBSN1/Systeme und Netzwerke(Release 5.0.8 |June 18,
 2001) at
 16.01.2003 13:32:37,
	Serialize complete at 16.01.2003 13:32:37
Content-Transfer-Encoding: 7bit
Content-Type: text/plain;
	charset="us-ascii"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N

Hi Andrew,

I'm not sure, but I guess you have to use the sql namespace
for the substitute-value element as well:
<sql:substitute-value sql:name="contributor_id"/>

HTH
Carsten

> -----Original Message-----
> From: Andrew Savory [mailto:savs@luminas.co.uk]On Behalf Of Andrew
> Savory
> Sent: Thursday, January 16, 2003 1:22 PM
> To: cocoon-users@xml.apache.org
> Subject: SQL Transformer substitute-value woes with 2.0.4
>
>
>
> Hi,
>
> As far as I can tell, using substitute-value with SQL Transformer does not
> work in 2.0.4 (and there aren't any examples of it in the samples,
> something I'll rectify if I ever get the darn thing working!).
>
> Here's what I've got:
>
> test.xml:
>
> <?xml version="1.0" encoding="iso-8859-1"?>
>
> <page xmlns:sql="http://apache.org/cocoon/SQL/2.0">
>
>   <sql:execute-query xmlns:sql="http://apache.org/cocoon/SQL/2.0">
>     <sql:query>
>       SELECT DISTINCT contributor_id, name FROM foo WHERE
> contributor_id='<substitute-value sql:name="contributor_id"/>'
>     </sql:query>
>   </sql:execute-query>
> </page>
>
> sitemap.xmap:
>
> <map:match pattern="contributor/*/list">
>   <map:generate src="test.xml"/>
>   <map:transform type="sql">
>     <map:parameter name="use-connection" value="bar"/>
>     <map:parameter name="contributor_id" value="{1}"/>
>   </map:transform>
>   <map:transform src="stylesheets/simple-xml2html.xsl"/>
>   <map:serialize/>
> </map:match>
>
> ... but in my sitemap.log, I get:
>
> DEBUG   (2003-01-16) 12:11.46:611   [sitemap.transformer.sql]
> (/contributor/1/list) Thread-33/AbstractSAXTransformer: END
> endRecording fragment=<?xml version="1.0" encoding="ISO-8859-1"?>
>
>                         SELECT DISTINCT id, contributor_id, name
> FROM contributor WHERE contributor_id='<substitute-value
> sql:name="contributor_id"/>'
> DEBUG   (2003-01-16) 12:11.46:617   [sitemap.transformer.sql]
> (/contributor/1/list) Thread-33/AbstractSAXTransformer: END
> endSerializedXMLRecording xml=
>                         SELECT DISTINCT id, contributor_id, name
> FROM contributor WHERE contributor_id=''
>
> DEBUG   (2003-01-16) 12:11.46:618   [sitemap.transformer.sql]
> (/contributor/1/list) Thread-33/SQLTransformer: QUERY IS "
>                         SELECT DISTINCT id, contributor_id, name
> FROM contributor WHERE contributor_id=''
>                 "
>
> ... as far as I can tell, the substitute value just doesn't work. I've
> tried swapping {1} for 1 in the sitemap, and that doesn't help.
>
> Any ideas?
>
>
> Andrew.
>
> --
> Andrew Savory                                Email: andrew@luminas.co.uk
> Managing Director                              Tel:  +44 (0)870 741 6658
> Luminas Internet Applications                  Fax:  +44 (0)700 598 1135
> This is not an official statement or order.    Web:    www.luminas.co.uk
>
> ---------------------------------------------------------------------
> 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>