Ok fine I am able to save XML file into a database.
But, now I have another question. Something related to the XML namespaces.
I have a XML file of the following format.
- <ns1:Table xmlns:ns1="http://something.com/ns1">
-
<ns1:TR>
-
<ns1:TD >some text </ns1:TD>
-
<ns1:TD >some text </ns1:TD>
-
<ns1:TD >some text </ns1:TD>
-
<ns1:TD >some text </ns1:TD>
-
</ns1:TR>
-
</ns1:Table>
I want to transform this XML Document using a .xsl file. I use something like this...
- <?xml version="1.0" encoding="utf-8"?>
-
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
-
-
<xsl:output method="xml" indent="yes" encoding="utf-8" omit-xml-declaration="yes"/>
-
-
<xsl:template match="/">
-
<xsl:for-each select="//Table">
-
<HTML>
-
<HEAD><TITLE>Some Title</TITLE></HEAD>
-
<TABLE>
-
<xsl:apply-templates select="TR"/>
-
</TABLE>
-
</HTML>
-
</xsl:for-each>
-
</xsl:template>
-
-
<xsl:template match="/TR">
-
<TR>
-
<xsl:apply-templates select="TD"/>
-
</TR>
-
</xsl:template>
-
-
<xsl:template match="/TD">
-
<TD>
-
Some thing.......
-
</TD>
-
</xsl:template>
-
-
</xsl:stylesheet>
How should I modify the above .xsl file so that I get the desired output.
Many thanks.