the output of an sql search. I suppose I could use sed to fix the xml
sheet into something more well behaved. ..
> 1. YourXMLisn't well formed.
> 2. To accurately decode escaped HTML, you would need an extension
> function or you could do it using a template that searches for and
> replaces all occurrences of the required entities.
> 2. Instead of trying to include HTML withinXML, I would rather let it
> contain what it is designed for - storage of data. To elaborate, myXMLwould rather be :
> ---
> <?xmlversion="1.0"?>
> <NewDataSet>
> <Table>
> <link>http://cas.sdss.org/dr7/en/tools/chart/navi.asp?
> ra=166.358&dec=-0.748596</link>
> <img>http://casjobs.sdss.org/ImgCutoutDR7/getjpeg.aspx?
> ra=166.358&dec=-0.748596&scale=0.40&width=120&height=120&am p;opt=</
> img>
> <name>J1105</name>
> <ra>16.25829</ra>
> <dec>-7.74849605</dec>
> <mag_g>18.9</mag_g>
> <id>587722982270959696</id>
> <sep>0.02</sep>
> </Table>
> </NewDataSet>
> ---
> And I would use the following XSLT to get an accurate result :
> ---
> <?xmlversion="1.0" encoding="ISO-8859-1"?>
> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/
> Transform">
> <xsl:output method='html' version='1.0' encoding='UTF-8' indent='yes'/
> <xsl:template match="/">
> <html>
> <body>
> <h2>Lots of Junk</h2>
> <table border="1">
> <tr bgcolor="#9acd32">
> <th align="left">pic</th>
> <th align="left">name</th>
> </tr>
> <xsl:for-each select="NewDataSet/Table">
> <tr>
> <td>
> <xsl:element name="a">
> <xsl:attribute name="href">
> <xsl:value-of select="link" />
> </xsl:attribute>
> <xsl:element name="img">
> <xsl:attribute name="src">
> <xsl:value-of select="img" />
> </xsl:attribute>
> </xsl:element>
> </xsl:element>
> </td>
> <td><xsl:value-of select="name" /></td>
> </tr>
> </xsl:for-each>
> </table>
> </body>
> </html>
> </xsl:template>
> </xsl:stylesheet>
> ---
> This way, I do not need to bother about escaping HTML tags because
> they are not present in theXML. TheXMLonly stores the data which
> will become the attributes of a tag.
> On Nov 20, 10:14 pm, Eoj <josephmeir...@gmail.com> wrote:
> > Hello, new toxmlmarkup, have a question. Need to display a hyperlink
> > in a marked upxmlfile, here is an excerpt. . .
> > =========================================================================== =====
> > <NewDataSet>
> > <Table>
> > <pic><a href=http://cas.sdss.org/dr7/en/tools/chart/
> > navi.asp?ra=166.358&dec=-0.748596>
> > <img src="http://casjobs.sdss.org/ImgCutoutDR7/getjpeg.aspx?
> > ra=166.358&dec=-0.748596&scale=0.40&width=120&height=120&am p;opt="/
> > > </pic>
> > <name>J1105<name>
> > <ra>16.25829</ra>
> > <dec>-7.74849605</dec>
> > <mag_g>18.9</mag_g>
> > <id>587722982270959696</id>
> > <sep>0.02</sep>
> > /Table>
> > </NewDataSet>
> > =======================================================
> > and the xsl is below. The table as displayed in html only has the long
> > link that is not clickable. How does one make a clickable hyperlink
> > from anxmldatabase?
> > ==================================================
> > <?xmlversion="1.0" encoding="ISO-8859-1"?>
> > <xsl:stylesheet version="1.0"
> > xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
> > <xsl:output method='html' version='1.0' encoding='UTF-8' indent='yes'/
> > <xsl:template match="/">
> > <html>
> > <body>
> > <h2>Lots of Junk</h2>
> > <table border="1">
> > <tr bgcolor="#9acd32">
> > <th align="left">pic</th>
> > <th align="left">name</th>
> > </tr>
> > <xsl:for-each select="NewDataSet/Table">
> > <tr>
> > <td><xsl:value-of select="pic"/></td>
> > <td><xsl:value-of select="name"/></td>
> > </tr>
> > </xsl:for-each>
> > </table>
> > </body>
> > </html>
> > </xsl:template>
> > </xsl:stylesheet>
