Re: SQL Transformer substitute-value woes with 2.0.4

[Jeremy Quinn]

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: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>