Return-Path: 
 <cocoon-users-return-44932-apmail-xml-cocoon-users-archive=xml.apache.org@xml.apache.org>
Delivered-To: apmail-xml-cocoon-users-archive@xml.apache.org
Received: (qmail 15948 invoked by uid 500); 17 Jan 2003 10:01:01 -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 15937 invoked from network); 17 Jan 2003 10:01:01 -0000
Date: Fri, 17 Jan 2003 10:01:08 +0000
Subject: Re: SQL Transformer substitute-value woes with 2.0.4
Content-Type: text/plain; charset=US-ASCII; format=flowed
Mime-Version: 1.0 (Apple Message framework v551)
From: Jeremy Quinn <jeremy@media.demon.co.uk>
To: cocoon-users@xml.apache.org
Content-Transfer-Encoding: 7bit
In-Reply-To: <Pine.LNX.4.51.0301161212180.1062@oxygen.internal.luminas.co.uk>
Message-Id: <99ACD186-2A02-11D7-B58F-0003935AD2EE@media.demon.co.uk>
X-Mailer: Apple Mail (2.551)
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N


On Thursday, Jan 16, 2003, at 12:21 Europe/London, Andrew Savory wrote:

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

<snip/>

>       SELECT DISTINCT contributor_id, name FROM foo WHERE 
> contributor_id='<substitute-value sql:name="contributor_id"/>'
>     </sql:query>

<snip/>

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

I use this in 2.1 successfully, did you try leaving the quotes out?

ie.

	SELECT DISTINCT contributor_id, name FROM foo WHERE contributor_id = 
<substitute-value sql:name="contributor_id"/>

this is how mine look ...

regards Jeremy


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