XML XSLT to table columns RSS

• • Reply
  

  jodyford

  Member

  100 Points

  20 Posts

  XML XSLT to table columns

  Sep 25, 2003 03:21 AM|LINK

  lets say I have the following XML file (very short version) generated from ASP.NET querying a SQL stored proc: - - Nixon Red Amber - Ford Green Green - Carter Amber Red - and I want this output (again, simplified):

  Nixon	Ford	Carter
  Red	Green	Amber
  Amber	Green	Red

  Can anyone help? I'm very new at XML/XSLT but, naturally, the client wants this asap. My brain hurts.
• • Reply
  

  joteke

  All-Star

  46284 Points

  6896 Posts

  ASPInsiders

  MVP

  Re: XML XSLT to table columns

  Sep 25, 2003 01:32 PM|LINK

  Hi, see this thread: 312987
  Thanks,
  
  Teemu Keiski
  Finland, EU
  
• • Reply
  

  jodyford

  Member

  100 Points

  20 Posts

  Re: XML XSLT to table columns

  Sep 25, 2003 02:52 PM|LINK

  are you sure thats along the correct axis?
• • Reply
  

  joteke

  All-Star

  46284 Points

  6896 Posts

  ASPInsiders

  MVP

  Re: XML XSLT to table columns

  Sep 25, 2003 03:33 PM|LINK

  Well, that would have you give you a start with thinking the approach. Anyway, try this

  Thanks,
  
  Teemu Keiski
  Finland, EU
  
• • Reply
  

  jodyford

  Member

  100 Points

  20 Posts

  Re: XML XSLT to table columns

  Sep 25, 2003 03:39 PM|LINK

  Thats perfect! What if I wanted to do this: (note row names) > >

  Name:	Nixon	Ford	Carter
  Base:	Red	Green	Amber
  Server:	Amber	Green	Red

• • Reply
  

  joteke

  All-Star

  46284 Points

  6896 Posts

  ASPInsiders

  MVP

  Re: XML XSLT to table columns

  Sep 25, 2003 03:43 PM|LINK

  Well, do you want to add them in the transformation? Just by having them on data like this would do it already: Name Base Server Nixon Red Amber Ford Green Green Carter Amber Red
  Thanks,
  
  Teemu Keiski
  Finland, EU
  
• • Reply
  

  jodyford

  Member

  100 Points

  20 Posts

  Re: XML XSLT to table columns

  Sep 25, 2003 03:49 PM|LINK

  I would, woudn't it? I have to change my store proc to get this information, but, hey, thats a great start. Thank you for your help. JF
• • Reply
  

  joteke

  All-Star

  46284 Points

  6896 Posts

  ASPInsiders

  MVP

  Re: XML XSLT to table columns

  Sep 25, 2003 04:02 PM|LINK

  Yeah, I was just thinking if that would have been preferred because then names would not be kept in XSLT file (when something changes). I mean if they were in the XSLT itself, stylsheet could look something like:

  xmlns:msxsl="urn:schemas-microsoft-com:xslt" exclude-result-prefixes="msxsl">
  	
  	
  
  
  		Name
  		Base
  		Server
  	
  	
  
  
  	
  
  
  		
  			
  			
  
  		
  	
  
  	
  
  
     
     
  
     
  
      
  
     
       
       
  
            

  Thanks,
  
  Teemu Keiski
  Finland, EU
  
• • Reply
  

  jodyford

  Member

  100 Points

  20 Posts

  Re: XML XSLT to table columns

  Sep 25, 2003 05:25 PM|LINK

  this is the XSLT I'm using: Question is there a way to use BOLD font for some of my "Names"? ---code---(edited) Aution LN Ser NA DMi DMu TC STANFINS AOC AMS IAA - G IAA - T Com ATS VMS OPOF ITC Visual In CC VC ---code---
• • Reply
  

  joteke

  All-Star

  46284 Points

  6896 Posts

  ASPInsiders

  MVP

  Re: XML XSLT to table columns

  Sep 25, 2003 05:38 PM|LINK

  Yes, you could put those which you need as bold as:

  The name

  And when outputting the name:

   
     
  				
  					< b >
  						
  					
  				
  				
  						
  				 
  		
       	
   
  

  Or do you mean bold for all items "under" that name. Say all in "Name" or "Server"?
  Thanks,
  
  Teemu Keiski
  Finland, EU