This is the mail archive of the xsl-list@mulberrytech.com mailing list .


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Distinct problem


Hello,

I would select a Nodeset with all "table"-Attributes from my XML.


my xml:

<QUERY version="1.0">
  <SELECT>
	<COL table="PCG_PZN">PZN</COL>
	<RESULTCOL table="PCG_Indikation" alias="igru" id="indigrup"
type="int">IndGr</RESULTCOL>
	<RESULTCOL table="PCG_Indikation"              id="indiname"
type="String">"Name"</RESULTCOL>
  </SELECT>
  <FROM>
        <TABLE>[zusätzliche Tabellen]</TABLE>
        <JOIN type="leftouter" left="PCG_PZN" right="JOIN PCG_FAM">
              <WHERE>
                    <COL table="PCG_PZN">Key_FAM</COL> = <COL
table="PCG_FAM">Key_FAM</COL> AND
                    <COL table="PCG_PZN">GBDatum</COL> = <COL
table="PCG_FAM">GBDatum</COL>
              </WHERE>
              <JOIN type="leftouter" right="PCG_Indikation">
                    <WHERE>
                          <COL table="PCG_FAM">HauptInd</COL> = <COL 
                    </WHERE>
              </JOIN>
        </JOIN>
  </FROM>
  <WHERE>
	<COL table="PCG_PZN">PZN</COL> = <PARAM id="pznid" type="int" />
  </WHERE>
</QUERY>


Like this:

<xsl:for-each select="///@table[not(@table = preceding::node()/@table)]">
    <xsl:value-of select="."/>,
</xsl:for-each> 

But this wont work. Any hints?


Best regards

Conny Kreyßel

INTER-FORUM Systemhaus GmbH
Sommerfelder Str. 120
04316 Leipzig
Germany

Tel.:  +49-341-25 92 00
Fax :  +49-341-25 92 020
WWW :  http://www.inter-forum.de/
eMail: mailto:conny.kreyssel@inter-forum.de 

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]