Two HTML Tables and Two XSLT with Two XML?

gman44 · February 28th, 2006, 11:11 PM

I cannot find anyone who can solve this problem. I've been everywhere too.

I have one DataSet.xsd with two tables and two .xml files, each table has it's own seperate xml.

DataSet1.xsd ------- datatable1 ---- datatable1.xml
                 ^------- datatable2 ---- datatable2.xml

Now, using the code above and applying your advice, the code below should look like this???

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"
  xmlns:tbl="http://tempuri.org/DataSet1.xsd" exclude-result-prefixes="tbl">

<xsl:template match="/">
  <html>
    <head>
        <title>Customers</title>
      </head>
    <body>
      <h1 style=" font-family:arial; font-size:12pt; font-weight:bold; text-align:left;">Customers:</h1>
      <table border="1" style="width:100%">
        <thead>
          <tr style =" font-family:arial; font-size:10pt; font-weight:bold; text-align:center; background-color:FAF8CC; cell-padding:10px">
            <td>Date/Time</td>
            <td>First Name</td>
            <td>Last Name</td>
            <td>Gender</td>
            <td>Age</td>
          </tr>
        </thead>
        <xsl:apply-templates/>
        <p></p>
      </table>

      <h1 style=" font-family:arial; font-size:12pt; font-weight:bold; text-align:left;">Jobs:</h1>
      <table border="1" style="width:100%">
        <thead>
          <tr style =" font-family:arial; font-size:10pt; font-weight:bold; text-align:center; background-color:FAF8CC; cell-padding:10px">
            <td>Date/Time</td>
            <td>Current</td>
            <td>Past</td>
          </tr>
        </thead>
        <xsl:apply-templates select="document('tableinfo.xml')//DataSet1"/>
      </table>
    </body>
  </html>
</xsl:template>

<xsl:template match="tbl:tablecustomers">
   <tr style =" font-family:arial; font-size:10pt; font-weight:normal; text-align:left; background-color:FFFFFF; cell-padding:10px">
     <td>
       <xsl:value-of select="tbl:datetime"/>
     </td>
     <td>
       <xsl:value-of select="tbl:firstname"/>
     </td>
     <td>
       <xsl:value-of select="tbl:lastname"/>
     </td>
     <td>
       <xsl:value-of select="tbl:gender"/>
     </td>
     <td>
       <xsl:value-of-select="tbl:age"/>
     <td>
   </tr>
</xsl:template>

<xsl:template match="tbl:primarykey"/>

<xsl:template match="tbl:tableinfo">
   <tr style =" font-family:arial; font-size:10pt; font-weight:normal; text-align:left; background-color:FFFFFF; cell-padding:10px">
     <td>
       <xsl:value-of select="tbl:datetime"/>
     </td>
     <td>
       <xsl:value-of select="tbl:current"/>
     </td>
     <td>
       <xsl:value-of select="tbl:past"/>
     </td>
   </tr>
</xsl:template>
<xsl:template match="tbl:primarykey"/>
</template>

joefawcett · March 1st, 2006, 04:53 AM

What are you trying to do?
Are you trying to create a stylesheet that will process the XSD and XML for one of the tables or both at the same time?

What exactly is the problem, you haven't said?
Can you show a small sample of the XSD and XML for one of the tables, or both if the straucture is radically different?

--

Joe (Microsoft MVP - XML)