Re: Linking SQL Transformer and XSL Transformer

[Olivier Billard]

Matt Rich wrote:

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...

Did you use the correct SQLTransformer namespace ?

>
>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...

No : The ESQL taglib only generates Java code for the XSP to be compiled.

--
Olivier

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]