Re: SQL Transformer substitute-value woes with 2.0.4

2003-01-17 Thread 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

RE: SQL Transformer substitute-value woes with 2.0.4

2003-01-17 Thread Carsten Ziegeler
Jeremy Quinn wrote: SELECT DISTINCT contributor_id, name FROM foo WHERE contributor_id = substitute-value sql:name=contributor_id/ this is how mine look ... And you do not use the sql namespace on the substitue-value element (sql:substitue-value sql:name=.../) or have the

Re: SQL Transformer substitute-value woes with 2.0.4

2003-01-17 Thread Jeremy Quinn
On Friday, Jan 17, 2003, at 10:04 Europe/London, Carsten Ziegeler wrote: Jeremy Quinn wrote: SELECT DISTINCT contributor_id, name FROM foo WHERE contributor_id = substitute-value sql:name=contributor_id/ this is how mine look ... And you do not use the sql namespace on the

RE: SQL Transformer substitute-value woes with 2.0.4

2003-01-16 Thread Carsten Ziegeler
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:[EMAIL PROTECTED]]On Behalf Of Andrew Savory Sent: Thursday,

RE: SQL Transformer substitute-value woes with 2.0.4

2003-01-16 Thread Andrew Savory
On Thu, 16 Jan 2003, Carsten Ziegeler wrote: 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/ Oh man, it's ALWAYS a simple solution. Thanks! Patch for docs sent to bugzilla and cocoon-dev, and

RE: SQL Transformer substitute-value woes with 2.0.4

2003-01-16 Thread Carsten Ziegeler
-Original Message- From: Andrew Savory [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew Savory Sent: Thursday, January 16, 2003 1:51 PM To: [EMAIL PROTECTED] Subject: RE: SQL Transformer substitute-value woes with 2.0.4 On Thu, 16 Jan 2003, Carsten Ziegeler wrote: I'm not sure