oops, I just ran your example on my machine, and it ran like a charm :-s I must say I'm running tomcat 4.0.4, cocoon 2.0.3 on java 1.4.0...
Koen > -----Oorspronkelijk bericht----- > Van: Simon Price [mailto:[EMAIL PROTECTED]] > Verzonden: vrijdag 30 augustus 2002 14:53 > Aan: [EMAIL PROTECTED] > Onderwerp: Re: problems generating input to sql transformer with > stylesheet (a la Langham & Ziegeler book) > > > Koen, thanks but I already tried this. The resultant xml using your > stylesheet is... > > <?xml version="1.0" encoding="UTF-8"?> > <user xmlns:xmlns:sql="http://apache.org/cocoon/SQL/2.0"> > <xmlns="http://apache.org/cocoon/SQL/2.0"> > <> > <>ecsnp</> > <>Price</> > <>Simon</> > </> > </> > </user> > > It sort of works but, for some reason, the rowset, row and column name > tags get omitted by the sql transformer!!! > > In case it helps anyone say why this is, here's the intermediate xml > from the stylesheet, before it goes into the sql transformer... > > <?xml version="1.0" encoding="UTF-8"?> > <user xmlns:sql="http://apache.org/cocoon/SQL/2.0"> > <sql:execute-query> > <sql:use-connection>pool-TAL</sql:use-connection> > <sql:query> > select > USERNAME, > SURNAME, > INITIALS > from > STAFF > where > STAFFID = '24' > </sql:query> > </sql:execute-query> > </user> > > Koen Pellegrims wrote: > > > try your stylesheet as follows: > > > > <?xml version="1.0"?> > > <xsl:stylesheet version="1.0" > > xmlns:xsl="http://www.w3.org/1999/XSL/Transform" > > xmlns:sql="http://apache.org/cocoon/SQL/2.0"> > > <xsl:template match="bootstrap"> > > <user> > > <sql:execute-query> > > <sql:use-connection>pool-TAL</sql:use-connection> > > <sql:query> > > select > > USERNAME, > > SURNAME, > > INITIALS > > from > > STAFF > > where > > STAFFID = '24' > > </sql:query> > > </sql:execute-query> > > </user> > > </xsl:template> > > </xsl:stylesheet> > > > > this is exactly the same approach you would take to generate fo, for > > example. > > > > Koen. > > > > > >>-----Oorspronkelijk bericht----- > >>Van: Simon Price [mailto:[EMAIL PROTECTED]] > >>Verzonden: vrijdag 30 augustus 2002 13:03 > >>Aan: [EMAIL PROTECTED] > >>Onderwerp: problems generating input to sql transformer with stylesheet > >>(a la Langham & Ziegeler book) > >> > >> > >>I'm having real problems doing a "trivial" tranformation (in the style > >>of Matthew and Carsten's excellent book). > >> > >>I generate xml which then gets transformed by the sql transformer. > >>Unfortunately, it only works if I have no containing elements in the > >>input to the transformer. I'm guessing its related to the namespace? Or > >>is it a bug in the sql transformer? Any suggestions welcomed! > >> > >>Here's the full details (stripped down to simplest repro so please don't > >>worry about the stylesheet now being pointless)... > >> > >> > >>version info: > >> > >>tomcat 4.0.1 > >>java 1.3.1 > >>cocoon 2.1 head > >> > >> > >>sitemap fragment: > >> > >> <map:match pattern="test3.xml"> > >> <map:generate src="model/bootstrap.xml"/> > >> <map:transform src="model/staff_model.xsl"/> > >> <map:transform type="sql"/> > >> <map:serialize type="xml"/> > >> </map:match> > >> > >> > >>model/bootstrap.xml: > >> > >><?xml version="1.0"?> > >><bootstrap/> > >> > >> > >>model/staff_model.xsl > >> > >><?xml version="1.0"?> > >><xsl:stylesheet version="1.0" > >> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" > >> xmlns:sql="http://apache.org/cocoon/SQL/2.0"> > >> <xsl:template match="bootstrap"> > >> <user> > >> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0"> > >> <use-connection>pool-TAL</use-connection> > >> <query> > >> select > >> USERNAME, > >> SURNAME, > >> INITIALS > >> from > >> STAFF > >> where > >> STAFFID = '24' > >> </query> > >> </execute-query> > >> </user> > >> </xsl:template> > >></xsl:stylesheet> > >> > >> > >>error in browser (reformatted by hand to make more readable): > >> > >>Multiple colons are not allowed in a name. Error processing resource > >>'http://localhost:8080/cocoon/tal/admin/test3.xml'. Line 2, Position 18 > >> > >><user xmlns:xmlns:sql="http://apache.org/cocoon/SQL/2.0"> > >> -----------------^ > >> <rowset xmlns="http://apache.org/cocoon/SQL/2.0" > >>xmlns:sql="http://apache.org/cocoon/SQL/2.0"> > >> <row> > >> <username>ecsnp</username> > >> <surname>Price</surname> > >> <initials>S</initials> > >> </row> > >> </rowset> > >></user> > >> > >>To help diagnose, the intermediate XML that comes out of the stylesheet > >>transformation, before going into the sql transformer is: > >> > >> <?xml version="1.0" encoding="UTF-8" ?> > >> <user xmlns:sql="http://apache.org/cocoon/SQL/2.0"> > >> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0"> > >> <use-connection>pool-TAL</use-connection> > >> <query>select USERNAME, SURNAME, INITIALS from STAFF where STAFFID = > >>'24'</query> > >> </execute-query> > >> </user> > >> > >>Contrast this with the XML at the same point if the root <user> element > >>is removed from the stylesheet (THIS ONE WORKS): > >> > >> <?xml version="1.0" encoding="UTF-8" ?> > >> <execute-query xmlns="http://apache.org/cocoon/SQL/2.0" > >>xmlns:sql="http://apache.org/cocoon/SQL/2.0"> > >> <use-connection>pool-TAL</use-connection> > >> <query>select USERNAME, SURNAME, INITIALS from STAFF where STAFFID = > >>'24'</query> > >> </execute-query> > >> > >> > >>Thanks in advance > >> > >>Simon > >> > >>------------------------------------------------------------------- > >>Simon Price > >>Institute for Learning and Research Technology > >>University of Bristol > >>8-10 Berkeley Square > >>Bristol BS8 1HH > >>United Kingdom > >> > >>Direct: +44 (0)7071 226 720 > >>Office: +44 (0)117 928 7193 > >>Fax: +44 (0)117 928 7112 > >>[EMAIL PROTECTED] > >>http://www.ilrt.bristol.ac.uk > >> > >> > >> > >>--------------------------------------------------------------------- > >>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]> > >> > >> > > > > > > --------------------------------------------------------------------- > > 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]> > > > > > -- > > ------------------------------------------------------------------- > Simon Price > Institute for Learning and Research Technology > University of Bristol > 8-10 Berkeley Square > Bristol BS8 1HH > United Kingdom > > Direct: +44 (0)7071 226 720 > Office: +44 (0)117 928 7193 > Fax: +44 (0)117 928 7112 > [EMAIL PROTECTED] > http://www.ilrt.bristol.ac.uk > > > --------------------------------------------------------------------- > 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]> > > --------------------------------------------------------------------- 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]>