XML, XSLT and XPATH

XML + XSL embedded into HTML

Please support our XML, XSLT and XPATH advertiser: Intel Parallel Studio Home

•

Join Date: Oct 2008

Posts: 1

Reputation: Anthraxnz is an unknown quantity at this point

Solved Threads: 0

Anthraxnz

Offline

Newbie Poster

XML + XSL embedded into HTML

Oct 8th, 2008

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.

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<?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>
<?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.

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<?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>
<?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.