RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

2003-03-18 Thread Luca Morandini
> -Original Message- > From: Delis, Christopher E. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 6:32 PM > To: '[EMAIL PROTECTED]' > Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL > upda te table???) > > > do you mi

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

2003-03-18 Thread Delis, Christopher E.
do you mind sharing the template? =-) --chris > -Original Message- > From: Luca Morandini [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 11:18 AM > To: [EMAIL PROTECTED] > Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

2003-03-18 Thread Luca Morandini
> -Original Message- > From: Delis, Christopher E. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 5:18 PM > To: '[EMAIL PROTECTED]'; 'Luca Morandini ' > Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL > upda te table

RE: sql transformer question; *not* esql... (was RE: ???ESQL upda te table???)

2003-03-18 Thread Delis, Christopher E.
zip = '' where library_id = > -Original Message- > From: Delis, Christopher E. [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 18, 2003 4:08 AM > To: 'Luca Morandini '; '[EMAIL PROTECTED] ' > Subject: RE: sql trans

Re: SQL Transformer or ESQL Stylesheet?

2003-03-18 Thread Andrew Savory
Hi, On Tue, 18 Mar 2003, Scherler wrote: > Konlin wrote: > > >Can you write me any clues when to use sql transformer and when esql > >stylesheet? > > I have ask that question before but with no answer! > My personal opinion is that you should use the SQL-transform [a] for > simple Queries where

Re: SQL Transformer or ESQL Stylesheet?

2003-03-18 Thread Scherler
Konlin wrote: Hello Cocoon! Can you write me any clues when to use sql transformer and when esql stylesheet? What is more flexible, easier, more professional etc? I'm going to write simple news portal with Xindice or MySQL as DBMS and I'm wondering what solution is better. Greetz, Konrad Inglot

RE: sql transformer question; *not* esql... (was RE: ???ESQL update table???)

2003-03-18 Thread Delis, Christopher E.
thanks! i am so embarassed. ;-) i gazed right past that little paragraph... sheesh! -Original Message- From: Luca Morandini To: [EMAIL PROTECTED] Sent: 3/18/03 1:15 AM Subject: RE: sql transformer question; *not* esql... (was RE: ???ESQL update table???) Christopher, IIUC, you need

RE: sql transformer question; *not* esql... (was RE: ???ESQL update table???)

2003-03-17 Thread Luca Morandini
Christopher, IIUC, you need substitution: go to http://xml.apache.org/cocoon/userdocs/transformers/sql-transformer.html and look for the "Substitution" topic Regards, - Luca Morandini GIS Consultant [EMAIL

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 = this is how mine look ... And you do not use the sql namespace on the substitue-value element (sql:substitue-value sql:name=".

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 = > > > 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 default namespace set to sql? Carsten

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 what

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 2

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: > Oh man, it's ALWAYS a simple solution. Thanks! Patch for docs sent to bugzilla and cocoon-dev, and I've added "create an SQL transformer sample

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: HTH Carsten > -Original Message- > From: Andrew Savory [mailto:[EMAIL PROTECTED]]On Behalf Of Andrew > Savory > Sent: Thursday, January 16, 2003 1:22 PM > To: [EMAIL PROTECTE

RE: SQL-Transformer

2002-12-13 Thread Geoff Howard
Original Message- From: Boris Althaus [mailto:[EMAIL PROTECTED]] Sent: Friday, December 13, 2002 10:15 AM To: [EMAIL PROTECTED] Subject: Re: SQL-Transformer mysql - Original Message - From: Geoff Howard To: [EMAIL PROTECTED] Sent: Friday, December 13, 2002 4:19 PM Subject: RE: SQL-Tra

Re: SQL-Transformer

2002-12-13 Thread Boris Althaus
mysql - Original Message - From: Geoff Howard To: [EMAIL PROTECTED] Sent: Friday, December 13, 2002 4:19 PM Subject: RE: SQL-Transformer There is a tag defined but it's not fully implemented, although it may be in the very latest cvs. (it only w

RE: SQL-Transformer

2002-12-13 Thread Geoff Howard
There is a tag defined but it's not fully implemented, although it may be in the very latest cvs. (it only worked for one particular database)  What database are you using?   Geoff Howard -Original Message-From: Boris Althaus [mailto:[EMAIL PROTECTED]]Sent: Friday, December 13,

RE: SQL Transformer with nested query + Filter Transformer = ArrayIndexOutOfBoundsException exception

2002-09-02 Thread Luca Morandini
Igor, may you show us your query, the relevant portion of the sitemap and a fragment of the SQLTransformer output ? Best regards, - Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.i

Re: Sql Transformer

2002-03-25 Thread William Moore
Markus Did you get ny replies off-list to your question? I too had lots of problems with SQLTransformer, but managed to find workarounds. In particular there seems to be a problem with namespaces. It is described (and fixed) by Christopher Watson in the message with subject "RE: Cocoon 2.0 r