derek
here's the sample of the xml file:
<requete id='1'>
<name>Collection</name>
<attributes>
<attribute><valuetitle>id_collection</valuetitle></attribute>
</attributes>
<tables>
<table>collection</table>
</tables>
</requete>
and here's a (simplified) sample from the transformation template:
<xsl:template name="reqpred">
SELECT
<xsl:for-each select= "attributes/attribute">
<xsl:value-of select="valuetitle"/>
</xsl:for-each>
FROM
<xsl:for-each select="tables/table">
<xsl:value-of select="."/>
</xsl:for-each>
etc..
</xsl:template>
With this I manage to generate the following :
SELECT libelle_collection FROM collection
What I want is to be able to execute this and display the result through my chained transformers.
I hope I'm clear enough for you to figure out what I want do do
If not, please ask for more samples.
and be sure I very happy that you help me
Matt
Le 22 juil. 04, à 11:44, Derek Hohls a écrit :
Matt
I think you will have to post a sample of the input
XML file and the reqparam.xsl file that is supposed
to do the transform, and we can see why its not
working the way it should...
Derek
Hello Derek[EMAIL PROTECTED] 2004/07/22 11:37:03 AM >>>
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
Hello![EMAIL PROTECTED] 2004/07/22 10:28:52 AM >>>
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]
--
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]
