I have written xslt for generating the insert into statement but in my xml thr are some nodes which are optional. In my node attribute is also present,so i have given two choose condition for the node as well for the attribute which contains test and otherwise condition for inserting null if node is not present and inserting the value if that node & attrubute is coming.But, i am getting value in my output but not the null when node is not present.Plz suggest where my xslt is wrong,xml and xslt are pasted below:


XML:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<root>
<test1>
<test2>

<test3>
<ABC>2012012</ABC>
<test4 />


<test4 />


<test4 />


<test4 />


</test3>
</test2>
</test1>

<test1>
<test2>

<test3>
<ABC>2012012</ABC>
<test4>

<DEF ghi="EA">-100.0</DEF>
</test4>
<test4>

<DEF ghi="EA">-100.0</DEF>
</test4>
<test4>

<DEF ghi="EA">-100.0</DEF>
</test4>
</test3>
</test2>
</test1>
</root>



XSLT:

<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0">
<xsl:output encoding="UTF-8" media-type="text/csv" method="text"/>
<xsl:template match="/">
<root>

<xsl:for-each select="//test1">

<xsl:for-each select="test2">

<xsl:for-each select="test3">
<xsl:variable name="ABC" select="ABC"/>

<xsl:for-each select="test4">

<xsl:variable name="DEF">
<xsl:choose>
<xsl:when test="not(DEF)">Null</xsl:when>
<xsl:otherwise>
<xsl:value-of select="DEF"/> </xsl:otherwise>
</xsl:choose>
</xsl:variable>


<xsl:variable name="ghi">
<xsl:choose>
<xsl:when test="DEF/@ghi='' or not(DEF/@ghi)">Null</xsl:when>
<xsl:otherwise>
<xsl:value-of select="DEF/@ghi"/>
</xsl:otherwise>
</xsl:choose>
</xsl:variable>










<xsl:value-of select="concat(&quot;INSERT INTO tablename (DEF,ghi,ABC ) VALUES ( '&quot; ,

$DEF,&quot;'&quot; ,&quot;,&quot;, &quot;'&quot; ,
DEF/@ghi,&quot;'&quot; ,&quot;,&quot;, &quot;'&quot; ,

$ABC, &quot;'&quot;, &quot;)&quot;, &quot;;&quot; )"/>



</xsl:for-each>
</xsl:for-each>

</xsl:for-each>

</xsl:for-each>
</root>
</xsl:template>
</xsl:stylesheet>

You seem to be declaring a variable named $DEF which you then don't use - I don't see any reference to $DEF in your stylesheet.

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

Hi Michael,
Thanks for the reply!!!!.
I have decalred the variable DEF(Node) & ghi(attribute of DEF node) in my stylesheet and then i am retrieving the values of both of them in the insert into statement in the stylesheet.My aim is to get the "null" if the node and attribute are not present in the xml and the respective values if they are present.
Please do let me know if i have muddled anything.

Perhaps you have written "DEF" when you intended "$DEF".

__________________
Michael Kay
http://www.saxonica.com/
Author, XSLT 2.0 and XPath 2.0 Programmer\'s Reference

Hi Michael,
Thanks!!!! ,now i am getting the "null" value when my node DEF is not present but still i am not getting the "null" in the attribute(ghi) of that node. I tried some syntax but i am still not getting the null values.Could you please suggest what should be the syntax for the attribute so that i get null values in my query.
Current output of the XSLT is mentioned below for your reference:


INSERT INTO tablename (DEF,ghi,ABC ) VALUES ( 'Null','','2012012');INSERT INTO tablename (DEF,ghi,ABC ) VALUES ( 'Null','','2012012');INSERT INTO tablename (DEF,ghi,ABC ) VALUES ( 'Null','','2012012');INSERT INTO tablename (DEF,ghi,ABC ) VALUES ( 'Null','','2012012');INSERT INTO tablename (DEF,ghi,ABC ) VALUES ( '-100.0','EA','2012012');INSERT INTO tablename (DEF,ghi,ABC ) VALUES ( '-100.0','EA','2012012');INSERT INTO tablename (DEF,ghi,ABC ) VALUES ( '-100.0','EA','2012012');

Still not getting "null" for the attribute(ghi) .Please Help

Well you haven't shown us your new XSLT, so it is hard to say what you are doing wrong as we're not mind readers. If you have replaced "DEF/@ghi" with $ghi in the output part of your XSLT then it should work.

__________________
/- Sam Judson : Wrox Technical Editor -/

Think before you post: What have you tried?

Hi Sam,
Thanks a lot!!!! ,I am getting the desired output.