Re: [C2b2] esql tags in xsl stylesheets
On 24.Aug.2001 -- 05:04 PM, Arnaud Vandyck wrote: Response below... Date: Fri, 24 Aug 2001 16:22:09 +0200 From: Orgalist [EMAIL PROTECTED] I can't make it work, the esql tags are not interpreted i also use esql tags in file.xsp where it works if someone can help me thanks. (I know similar questions have been posted, but i could find a solution in the answers ) C. here's the namespace in my xsp file ===file.xsp=== xsp:page language=java xmlns:xsp=http://apache.org/xsp; xmlns:esql=http://apache.org/cocoon/SQL/v2; ... /xsp:page the part of the xsl i'd like to see working : ==file.xsl= ?xml version=1.0 encoding=ISO-8859-1? xsl:stylesheet version=1.0 xmlns:esql=http://apache.org/cocoon/SQL/v2; xmlns:xsl=http://www.w3.org/1999/XSL/Transform; Impossible to do that! The esql *must* be in an xsp or xml page, never in the stylesheet. The esql tags will be removed when processing by Cocoon so you even can not match esql tags in xsl. Read the docs/samples/xsp/esql.xsp example or the employee examples (see the sitemap to know where to find it, must be in docs/samples/forms/employee.x* (xsp and xml)). If it hasn't changed recently, this is not true. Otherwise it would be impossible to chain taglibs. It is perfectly OK to use esql in a taglib stylesheet. Actually, the code looks quite OK to me and I don't have a clue why it shouldn't work. Note that differentiating between taglib stylesheets and formating stylesheets is important here: I usually refer to the former only as taglib and to the latter as stylesheet. Arnaud is right about any logic in stylesheets (including of course the use of esql), while I refer above only to taglibs. Unfortunately, orgalist didn't specify which he is refering to. But if it didn't work, he could have meant indeed stylesheets. Orgalist, please have a look at the sql transformer then, this might be the way to go. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[C2b2] esql tags in xsl stylesheets
I can't make it work, the esql tags are not interpreted i also use esql tags in file.xsp where it works if someone can help me thanks. (I know similar questions have been posted, but i could find a solution in the answers ) C. here's the namespace in my xsp file ===file.xsp=== xsp:page language=java xmlns:xsp=http://apache.org/xsp; xmlns:esql=http://apache.org/cocoon/SQL/v2; ... /xsp:page the part of the xsl i'd like to see working : ==file.xsl= ?xml version=1.0 encoding=ISO-8859-1? xsl:stylesheet version=1.0 xmlns:esql=http://apache.org/cocoon/SQL/v2; xmlns:xsl=http://www.w3.org/1999/XSL/Transform; xsl:template match=columns mode=add xsl:apply-templates select=col mode=add/ /xsl:template xsl:template match=col mode=add xsl:variable name=nomxsl:value-of select=name/.//xsl:variable xsl:variable name=typexsl:value-of select=type/.//xsl:variable xsl:if test=$nom!='id' td xsl:choose xsl:when test=starts-with($nom, 'text_') xsl:value-of select=substring-after($nom,'_')/ /xsl:when xsl:otherwise xsl:value-of select=$nom/ /xsl:otherwise /xsl:choose xsl:choose xsl:when test=starts-with($nom, '_') esql:connection esql:driverorg.gjt.mm.mysql.Driver/esql:driver esql:dburljdbc:mysql://xx/listes/esql:dburl esql:username/esql:username esql:password*/esql:password esql:execute-query esql:query select * from esql:parameterxsl:value-of select=substring-after(substring-before($nom,'__'),'_')//esql:parameter /esql:query esql:results esql:row-results esql:get-string column=type/ /esql:row-results /esql:results /esql:execute-query /esql:connection /xsl:when xsl:otherwise /xsl:otherwise /xsl:choose /td /xsl:if /xsl:template - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [C2b2] esql tags in xsl stylesheets
Response below... Date: Fri, 24 Aug 2001 16:22:09 +0200 From: Orgalist [EMAIL PROTECTED] I can't make it work, the esql tags are not interpreted i also use esql tags in file.xsp where it works if someone can help me thanks. (I know similar questions have been posted, but i could find a solution in the answers ) C. here's the namespace in my xsp file ===file.xsp=== xsp:page language=java xmlns:xsp=http://apache.org/xsp; xmlns:esql=http://apache.org/cocoon/SQL/v2; ... /xsp:page the part of the xsl i'd like to see working : ==file.xsl= ?xml version=1.0 encoding=ISO-8859-1? xsl:stylesheet version=1.0 xmlns:esql=http://apache.org/cocoon/SQL/v2; xmlns:xsl=http://www.w3.org/1999/XSL/Transform; Impossible to do that! The esql *must* be in an xsp or xml page, never in the stylesheet. The esql tags will be removed when processing by Cocoon so you even can not match esql tags in xsl. Read the docs/samples/xsp/esql.xsp example or the employee examples (see the sitemap to know where to find it, must be in docs/samples/forms/employee.x* (xsp and xml)). Hope it helps, --Arnaud - Please check that your question has not already been answered in the FAQ before posting. http://xml.apache.org/cocoon/faqs.html To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]