Hello Derek
Le 22 juil. 04, � 11:27, Derek Hohls a �crit :
Matt
When you say "The requests are correctly generated"
do you mean the SQL is in the right XML wrappers and
format to be processed by the SQL transformer...
No, that's precisely that I can't have the wrappers appear
that's why I wanted to generate them with <xsl:element...>
The query itself is correct when tested directly on the database
How shall I make the request visible for the SQL Transformer
after the first XSL Transformation?
I thank you for being so helpful!!
Matt
[EMAIL PROTECTED] 2004/07/22 10:28:52 AM >>>
Hello!
Thanks for your answer.
Here's my code :
(in reqparam.xsl)
<!-- i fetch the xml data necessary to generate the request-->
<xsl:for-each select="/requetes/requetesparam/[EMAIL PROTECTED] $noreq]">
<sql:execute-query>
<sql:query>
<!-- I call the template that generates the request -->
<xsl:call-template name="reqpred"/>
</sql:query>
</sql:execute-query>
</xsl:for-each>
and here's my pipeline:
<map:match pattern="reqparam">
<map:generate src="requetes.xml" />
<map:transform src="reqparam.xsl"/>
<map:transform type="sql">
<map:parameter name="use-connection" value="syb"/>
<map:parameter name="show-nr-of-rows" value="true"/>
<map:parameter name="clob-encoding" value="UTF-8"/>
</map:transform>
<map:transform src="stylesheets/sql2html.xsl"/>
<map:serialize/>
</map:match>
The requests are correctly generated, but i can't have them executed,
(so i can't display the data their execution must retrieve).
Is anything wrong?
Thank you!!!
Matt
PS : Is it possible to use the ESQL taglib in a XSL stylesheet?
I've read that esql was only for XSPs...
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
MailScanner thanks transtec Computers for their support.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
