🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: fr.comp.text.xml
Article #8635

D�butant : XML et XSL

#8635
From: FLUTE
Date: Fri, 07 Sep 2001 08:57
49 lines
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-mail

Show 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