Re: Big Problems with the SQL-Transformator

2005-01-28 Thread Frank Rennekamp
Hi Ben, well, yeah, it's working. Don't know what I made wrong before, because I tried this, too. Mea culpa. But actually this was only the simple form of the real problem, my SQL-Statement looks like: http://apache.org/cocoon/SQL/2.0";> SELECTid,lastname,firstname,title

Re: Big Problems with the SQL-Transformator

2005-01-28 Thread Ben Anderson
I think you just need to add end the sql:execute-query tag and restart it again... > > http://apache.org/cocoon/SQL/2.0";> > > SELECT lastname FROM person WHERE > id=123 > SELECT street,zipcode,city FROM address > WHERE person=123 > > --

Big Problems with the SQL-Transformator

2005-01-28 Thread Frank Rennekamp
Hi, I'm using Cocoon 2.1.6 on a debian system and discovered serious problems with the SQL-Transformer. The documentation to the SQL-Transformer mentioned, that I can have a sequence of queries I want to execute. But when I try something like: test.xml http://apache.org/cocoon/SQL/2