Article View: fr.comp.text.xml
Article #8635D�butant : XML et XSL
From: FLUTE
Date: Fri, 07 Sep 2001 08:57
Date: Fri, 07 Sep 2001 08:57
49 lines
2852 bytes
2852 bytes
J'ai le fichier xml suivant :
<root xmlns:sql="urn:schemas-microsoft-com:xml-sql" sql:xsl="Myxsl.xsl">
<sql:query>
select nom, prenom
from T_employes
for xml auto
</sql:query>
</root>
J'ai la feuille se style suivante :
<?xml version='1.0' encoding='UTF-8'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0">
<xsl:output media-type = "text/html"/>
<xsl:template match = '*'>
<xsl:apply-templates />
</xsl:template>
<xsl:template match = 'T_Employes'>
<TR>
<TD><xsl:value-of select = '@Nom' /></TD>
<TD><B><xsl:value-of select = '@Prenom' /></B></TD>
</TR>
</xsl:template>
<xsl:template match = '/'>
<HTML>
<HEAD>
<STYLE>th { background-color: #CCCCCC }</STYLE>
</HEAD>
<BODY>
<TABLE border='1' style='width:300'>
<TR><TH colspan='2'>Employes</TH></TR>
<TR><TH >Nom</TH><TH>Prenom</TH></TR>
<xsl:apply-templates select = 'root' />
</TABLE>
</BODY>
</HTML>
</xsl:template>
</xsl:stylesheet>
Cete exercice est tir�e de la doc sql serveur 2000 mais en r�sultat je n'ai
que le haut du tableau gris�....pas les donn�es de ma base. O� est l'erreur
?????
Merci
sfp@edufrance.fr
Technical Details
Message-ID:
<9na24u$qko$1@wanadoo.fr>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!193.251.151.101!opentransit.net!wanadoo.fr!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: FRENCH,ASCII X-Google-Thread: 114f60,df519c89c80515e7,start X-Google-Attributes: gid114f60,public X-Google-ArrivalTime: 2001-09-07 01:57:02 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!newsfeed.stanford.edu!news.tele.dk!small.news.tele.dk!193.251.151.101!opentransit.net!wanadoo.fr!not-for-mail From: FLUTE <sfp@edufrance.fr> Newsgroups: fr.comp.text.xml Subject: D�butant : XML et XSL Date: 7 Sep 2001 08:57:02 GMT Organization: Wanadoo, l'internet avec France Telecom Lines: 49 Message-ID: <9na24u$qko$1@wanadoo.fr> NNTP-Posting-Host: amontsouris-101-2-1-30.abo.wanadoo.fr X-Trace: wanadoo.fr 999853022 27288 193.251.54.30 (7 Sep 2001 08:57:02 GMT) X-Complaints-To: abuse@wanadoo.fr NNTP-Posting-Date: 7 Sep 2001 08:57:02 GMT User-Agent: Xnews/4.06.22