Hi Johannes, You say Cocoon copies everything through when you use <xsl:copy-of select="."/>, but what happens when you use <xsl:copy-of select="sql:email"/>? What does your source SQL XML look like?
I suspect the xpath in your <copy-of select /> probably just needs a little adjusting, but without seeing your source XML it's hard to say for sure. Heather -----Original Message----- From: Johannes Hoechstaedter [mailto:[EMAIL PROTECTED] Sent: 09 June 2008 15:50 To: users@cocoon.apache.org Subject: xsl:copy-of select Hallo everybody, I have the following problem. I transform an sql statement by a xsl stylsheet: which looks like the following: <?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" xmlns:ft="http://apache.org/cocoon/forms/1.0#template"> <xsl:template match="/page"> <html> <body> <table border = "1"> <xsl:copy-of select="sql:email"/> <xsl:apply-templates/> </table> </body> </html> </xsl:template> ................................. Everything works fine except the copy-of select statement. I want to acces a single field from the sql statement. When I type <xsl:copy-of select="."/> cocoon prints the whole resultset to the screen. I already tried ${sql:email}, or thing like name()="sql:email", but nothing works for me. Thanks for any advice. The sitemap statement looks like this: <map:match pattern = "runsql"> <map:generate src="resource/internal/sql/sql.xml"/> <map:transform type="sql"> <map:parameter name="use-connection" value="personnel"/> <map:parameter name="show-nr-of-rows" value="true"/> <map:parameter name="clob-encoding" value="UTF-8"/> </map:transform> <map:transform src="resource/internal/transform2Table.xsl"/> <map:serialize type="html"/> </map:match> cheers --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] http://www.bbc.co.uk/ This e-mail (and any attachments) is confidential and may contain personal views which are not the views of the BBC unless specifically stated. If you have received it in error, please delete it from your system. Do not use, copy or disclose the information in any way nor act in reliance on it and notify the sender immediately. Please note that the BBC monitors e-mails sent or received. Further communication will signify your consent to this. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]