Forum

Forum Home

XML

XSLT, XPath and XQuery

XSL question...

XSL question

naijacoder

1 posts

Joined
2/21/2006

XSL question
Posted: 21 Feb 06 10:39 PM (Australia)

I have an sample xml below.
I want to do a distinct on the code node and the programDescription.
I want the output to be like in a tree structure.
So i would like to have
PRG004 >Crazy Training 2> MAT01
                                             PHS101
Any ideas it musn't be in a tree but it could be in a table structure
Thanks

<?xml version="1.0" standalone="yes"?>
<?xml-stylesheet type="text/xsl" href="email.xsl"?>
<NewDataSet>
   <ProgramDetail>
      <Code>PRG004</Code>

      <programDescription>Crazy Training 2</programDescription>

      <CourseCode>MAT01</CourseCode>

      <DurationHours>8</DurationHours>

      <CourseDescription>Maths For Beginners</CourseDescription>

      <ModuleCode>TEST101</ModuleCode>

      <ModuleDescription>Test Module</ModuleDescription>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG004</Code>

      <programDescription>Crazy Training 2</programDescription>

      <CourseCode>PHS101</CourseCode>

      <DurationHours>36</DurationHours>

      <CourseDescription>Physics</CourseDescription>

      <ModuleCode>TEST101</ModuleCode>

      <ModuleDescription>Test Module</ModuleDescription>

      <PreReqCourseCode>MAT234</PreReqCourseCode>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG004</Code>

      <programDescription>Crazy Training 2</programDescription>

      <CourseCode>PHS101</CourseCode>

      <DurationHours>36</DurationHours>

      <CourseDescription>Physics</CourseDescription>

      <ModuleCode>TEST103</ModuleCode>

      <ModuleDescription>TESTMODULEWITHLONGNAME</ModuleDescription>

      <PreReqCourseCode>MAT234</PreReqCourseCode>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG005</Code>

      <programDescription>Program 6</programDescription>

      <CourseCode>COURSE102</CourseCode>

      <DurationHours>5</DurationHours>

      <CourseDescription>Course for learning Courses</CourseDescription>

      <ModuleCode>MODULE101</ModuleCode>

      <ModuleDescription>Module 1</ModuleDescription>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG005</Code>

      <programDescription>Program 6</programDescription>

      <CourseCode>MAT01</CourseCode>

      <DurationHours>8</DurationHours>

      <CourseDescription>Maths For Beginners</CourseDescription>

      <ModuleCode>TEST101</ModuleCode>

      <ModuleDescription>Test Module</ModuleDescription>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG005</Code>

      <programDescription>Program 6</programDescription>

      <CourseCode>MAT234</CourseCode>

      <DurationHours>8</DurationHours>

      <CourseDescription>Maths</CourseDescription>

      <ModuleCode>TEST101</ModuleCode>

      <ModuleDescription>Test Module</ModuleDescription>

      <PreReqCourseCode>MAT01</PreReqCourseCode>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG005</Code>

      <programDescription>Program 6</programDescription>

      <CourseCode>MAT234</CourseCode>

      <DurationHours>8</DurationHours>

      <CourseDescription>Maths</CourseDescription>

      <ModuleCode>TEST101</ModuleCode>

      <ModuleDescription>Test Module</ModuleDescription>

      <PreReqCourseCode>MAT101</PreReqCourseCode>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG005</Code>

      <programDescription>Program 6</programDescription>

      <CourseCode>MAT234</CourseCode>

      <DurationHours>8</DurationHours>

      <CourseDescription>Maths</CourseDescription>

      <ModuleCode>TEST101</ModuleCode>

      <ModuleDescription>Test Module</ModuleDescription>

      <PreReqCourseCode>PHS101</PreReqCourseCode>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG005</Code>

      <programDescription>Program 6</programDescription>

      <CourseCode>MAT234</CourseCode>

      <DurationHours>8</DurationHours>

      <CourseDescription>Maths</CourseDescription>

      <ModuleCode>TEST102</ModuleCode>

      <ModuleDescription>TestModule2</ModuleDescription>

      <PreReqCourseCode>MAT01</PreReqCourseCode>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG005</Code>

      <programDescription>Program 6</programDescription>

      <CourseCode>MAT234</CourseCode>

      <DurationHours>8</DurationHours>

      <CourseDescription>Maths</CourseDescription>

      <ModuleCode>TEST102</ModuleCode>

      <ModuleDescription>TestModule2</ModuleDescription>

      <PreReqCourseCode>MAT101</PreReqCourseCode>
   </ProgramDetail>

   <ProgramDetail>
      <Code>PRG005</Code>

      <programDescription>Program 6</programDescription>

      <CourseCode>MAT234</CourseCode>

      <DurationHours>8</DurationHours>

      <CourseDescription>Maths</CourseDescription>

      <ModuleCode>TEST102</ModuleCode>

      <ModuleDescription>TestModule2</ModuleDescription>

      <PreReqCourseCode>PHS101</PreReqCourseCode>
   </ProgramDetail>
</NewDataSet>

olegt

85 posts

www.xmllab.net

Joined
2/25/2005

Re: XSL question
Posted: 23 Feb 06 5:07 AM (Israel)

Sorry, but it's not very clear what kind of output do you need. Provide desired output please.

Oleg Tkachenko, Microsoft MVP for XML, MCPD
http://www.XmlLab.Net | http://blog.tkachenko.com

Page 1 of 1

XML

XSLT, XPath and XQuery

XSL question...