im new  XML and After reading all the various posts im Extremely Confused. 
My Company is requesting that i export Data from the DB into xml for Data 
transfer services. I see alot of Different methods,Elements,Members ect... 
and Sub queries on Data contained within XML schema. Im in need of 
exporting data from MsSQL for Plant Production Declarations to our SAP 
systems. It looks like XML is a whole lot of work Versus just straight 
Transactions to the source. What is the real Purpose of XML?
Thanks for your Help
Alan Cannon
Process / Automation SCADA Engineer
Plastic Omnium
50 tyger river rd
Duncan, S.C 29344
864 622-3221 (OFFICE)
864 245-6807 (CELL)
Email: acannon@p...
Please consider your environmental responsibility before printing this 
e-mail 



Jack Bush <netbeansfan@y...> 
02/02/2009 04:03 PM

To
xml-dev@l...
cc

Subject
[xml-dev] XSTL stylesheet workarounds for exceptions






Hi All,
 
I am at a stage of fine-tuning an existing stylesheet that has been worked 
on recently and would like include some workarounds to accommodate 
exceptional data in the following 2 areas: 
 
( i ) Get the content of sub-elements <a> as follows:
<p>
  <strong>Hobbies:</strong> 
  <a shape="rect" href=http://www.hobbies.com/fishing title="Shark 
Hunting">fishing</a> 
  <a shape="rect" href=http://www.hobbies.com/hunting title="Animal">
rabbit</a> 
(Out-door adventures)
</p>
 
Intended output
<hobbies> fishing<hobbies>
<hobbies> rabbit<hobbies>
 
In this case, it is both fishing, rabbit that I am after. However, I still 
couldn?t get it working despite having tried numerous of the following 
stylesheet approaches: 
 
<xsl:template match="/">
  <employee>
    <xsl:apply-templates select="//ns:p"/>
  </employee>
</xsl:template>
 
( A ) <xsl:template match="ns:p[ns:strong='Hobbies:']"> 
         <xsl:copy-of 
           <hobbies>select="ns:a"/></hobbies> 
       </xsl:template> 
               or
( B ) <xsl:template match="ns:p[ns:strong='Hobbies:']"> 
         <xsl:for-each select="ns:a/text()[normalize-space() != '']"> 
           <hobbies><xsl:value-of select="normalize-space()"/></hobbies> 
         </xsl:for-each> 
       </xsl:template> 
               or
( C ) <xsl:template match="ns:p[ns:strong='Hobbies:']"> 
         <xsl:for-each select=".//ns:a/text()[normalize-space() != '']"> 
           <hobbies><xsl:value-of select="normalize-space()"/></hobbies> 
         </xsl:for-each> 
       </xsl:template>
              or
( D ) <xsl:template match="ns:p[ns:strong='Hobbies:']"> 
         <xsl:for-each select="ns:p/ns:a/text()[normalize-space() != '']"> 

           <hobbies><xsl:value-of select="normalize-space()"/></hobbies> 
         </xsl:for-each> 
       </xsl:template>
               or
( E ) <xsl:template match="ns:p[ns:strong='Hobbies:']"> 
         <xsl:for-each select="../ns:a//text()[normalize-space() != '']">
           <hobbies><xsl:value-of select="normalize-space()"/></hobbies> 
         </xsl:for-each> 
       </xsl:template>
               or
( F ) <xsl:template match="ns:p[ns:strong='Hobbies:']"> 
         <xsl:for-each select="ns:a">
          <xsl:for-each select="text()[normalize-space() != '']">"
            <hobbies><xsl:value-of select="normalize-space()"/></hobbies> 
          </xsl:for-each> 
        </xsl:for-each> 
     </xsl:template>
               or 
( G ) <xsl:template match="ns:p[ns:strong='Hobbies:']"> 
          <xsl:for-each select=".//ns:a">
            <xsl:for-each select="text()[normalize-space() != '']">"
              <hobbies><xsl:value-of 
select="normalize-space()"/></hobbies> 
            </xsl:for-each> 
          </xsl:for-each>
        </xsl:template>
 
( ii ) I also like to add a default generic value for any missing element. 
Say if there are no 
<p><strong>Hobbies:</strong></p> element in such document, yet I still 
would like to generate a 
null element such as <hobbies>Unknown</hobbies>. The intended stylesheet 
should look 
like the following but again couldn?t get it working still:
 
<xsl:template match="/">
  <employee>
    <xsl:apply-templates select="//ns:p"/>
  </employee>
</xsl:template>
 
<xsl: choose>
  <xsl: when test="ns:p[ns:strong='Hobbies:']">
    <xsl:template match="ns:p[ns:strong='Hobbies:']"> 
      <xsl:for-each select="text()[normalize-space() != '']"> 
        <hobbies><xsl:value-of select="normalize-space()"/></hobbies> 
      </xsl:for-each> 
    </xsl:template>
  </xsl:when>
<xsl:otherwise>
  <hobbies>Unknown</hobbies> 
</xsl:otherwise>
</xsl: choose>
 
I have run out of ideas and would be very much appreciated if anyone could 
give me some suggestion on how to tackle this task.
Jack



Stay connected to the people that matter most with a smarter inbox. Take a 
look.