XML / XSL

Stuart Dootson wrote:

Still doesn't answer the question I asked you

led mike wrote:

At this point I wouldn't tell him sh*t.

key = CInt(j.ChildNodes(0).InnerText)

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:template match="/">
    <table>
      <xsl:for-each select="Compare/columnNames/column">
        <tr>
          <xsl:variable name="ColName" select="na"></xsl:variable>
          <td>
            <xsl:value-of select="na"/>
          </td>
          <xsl:for-each select="///Compare/Hotels/Hotel">
            <td>
              <xsl:value-of select="./*[name()=$ColName]"/>
            </td>
          </xsl:for-each>
        </tr>
      </xsl:for-each>
    </table>
  </xsl:template>
</xsl:stylesheet>

<?xml version="1.0"?>
<table>
  <tr>
    <td>Name</td>
    <td>Hotel Mount View</td>
    <td>Hotel Mayur</td>
  </tr>
  <tr>
    <td>Address</td>
    <td>123</td>
    <td>Adress1</td>
  </tr>
  <tr>
    <td>Phone</td>
    <td>1234</td>
    <td>12345678</td>
  </tr>
</table>

paypony wrote:

How to make menubar using XML code?

1. You can't use the ref attribute of the element element without using some level of XML namespaces.
2. You've omitted the Permission elements from your sample files
3. Your closing Permissions tags are incorrect - I'll presume that's a typo

<?xml version="1.0" encoding="utf-8"?>
<xs:schema
    targetNamespace="http://test-namespace.com/"
    xmlns="http://test-namespace.com/"
    xmlns:srd="http://test-namespace.com/"
    elementFormDefault="qualified" attributeFormDefault="unqualified"
    xmlns:xs="http://www.w3.org/2001/XMLSchema">

   <xs:element name="Roles">
      <xs:complexType>
         <xs:sequence>
            <xs:element ref ="Role"/>
         </xs:sequence>
      </xs:complexType>
   </xs:element>

   <xs:element name ="Role">
      <xs:complexType>
         <xs:sequence>
            <xs:element ref="Permissions"/>
         </xs:sequence>
      </xs:complexType>
   </xs:element>

   <xs:element name ="Permissions">
      <xs:complexType>
         <xs:sequence>
            <xs:element name ="Permission" type="xs:string" />
         </xs:sequence>
      </xs:complexType>
   </xs:element>


</xs:schema>

<?xml version="1.0" encoding="utf-8"?>
<Roles xmlns="http://test-namespace.com/">
   <Role>
      <Permissions>
         <Permission>Reader</Permission>
      </Permissions>
   </Role>
   <Permissions>
      <Permission>Reader</Permission>
   </Permissions>
</Roles>

<?xml version="1.0" encoding="utf-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">

   <xs:element name="Roles">
      <xs:complexType>
         <xs:sequence>
            <xs:element name ="Role">
               <xs:complexType>
                  <xs:sequence>
                     <xs:element name ="Permissions">
                        <xs:complexType>
                           <xs:sequence>
                              <xs:element name ="Permission" type="xs:string" />
                           </xs:sequence>
                        </xs:complexType>
                     </xs:element>
                  </xs:sequence>
               </xs:complexType>
            </xs:element>
         </xs:sequence>
      </xs:complexType>
   </xs:element>

</xs:schema>

tprakash wrote:

The XML file I am validating is from my clients. They cannot bear any change modification on that xml because it is being used by many others clients