sorry if this is a dumb FAQ type question, but i have been searching all morning for a answer.
Heres the setup.
I have an Oracle 10g DB outputting Relational Tables into XML.
heres an example out some output.
<?xml version = '1.0' encoding="ISO-8859-1"?>
<?xml-stylesheet href="blog.xsl" type="text/xsl"?>
<ROWSET>
<ROW num="1">
<B_PAGE>6206</B_PAGE>
<B_TYPE>course</B_TYPE>
<B_TITLE>Aims:</B_TITLE>
<B_AUTHOR>Steve Mckinlay</B_AUTHOR>
<B_DATE>10/1/2008 0:0:0</B_DATE>
<B_BODY>To give students an understanding of database design.</body>
</ROW>
</ROWSET>im using a XSL stylesheet to style the data stored in the XML file.
<?xml version="1.0" encoding="ISO-8859-1"?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
<xsl:template match="/">
<html>
<body>
<xsl:for-each select="ROWSET">
<xsl:for-each select="ROW">
<p>
<td><xsl:value-of select="B_BODY"/></td>
<td><xsl:value-of select="B_AUTHOR"/></td>
</p>
</xsl:for-each>
</xsl:for-each>
</body>
</html>
</xsl:template>
</xsl:stylesheet>Now thats the underlying functionality done, i also have a plain old HTML homepage; i need to get the styled XML\XSL content onto it in amongst the other HTML stuff on that page ( its not much just a couple of <p> and <IMG>)
the problem is that the .xml file is somewhat dynamic and it will be overwritten alot so that leaves out putting the html content in there.
what i would basically like is to open the .xml file with its styling and display the styled content on my HTML page.
Can anyone help me please :) i really stuck on this one, i looked at JAVA and some <XML> thing but couldn't understand how they worked.