RE: How to get unique data

What a pity we can't post little video clips. 
The one of John Cleese banging his head on the check-in desk at Faulty
Towers comes to mind. But then so does the little clip of him thrashing
his car with a tree branch. Until someone finds a link to this clip
maybe you should look at http://www.netcrucible.com/

Ciao Chris

XML/XSL Portal
http://www.bayes.co.uk/xml


> -----Original Message-----
> From: owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx 
> [mailto:owner-xsl-list@xxxxxxxxxxxxxxxxxxxxxx] On Behalf Of Rick Zhang
> Sent: 07 November 2001 22:57
> To: XSL-List@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  How to get unique data
> 
> 
> Hi,
>     In SQL "Select Distinct ...." can get the unique data 
> form the specify table. But in xml I can not do the same work.
> 
>     The data is as following:
>     <prog pid="0">
>         <item iid="0" fid="1"/>
>         <item iid="0" fid="2"/>
>         <item iid="0" fid="3"/>
>         <item iid="0" fid="4"/>
>         <item iid="0" fid="5"/>
>         <item iid="1" fid="6"/>
>         <item iid="1" fid="7"/>
>         <item iid="1" fid="8"/>
>         <item iid="1" fid="9"/>
>         <item iid="1" fid="10"/>
>     </prog>
>     <prog pid="1">
>         <item iid="2" fid="11"/>
>         <item iid="2" fid="12"/>
>         <item iid="2" fid="13"/>
>         <item iid="2" fid="14"/>
>         <item iid="2" fid="15"/>
>         <item iid="3" fid="16"/>
>         <item iid="3" fid="17"/>
>         <item iid="3" fid="18"/>
>         <item iid="3" fid="19"/>
>         <item iid="3" fid="20"/>
>     </prog>
> 
>     How can I use xsl in IE to get the follow data:
>     <prog pid="0">
>         <item iid="0" fid="1"/>
>         <item iid="1" fid="6"/>
>     </prog>
>     <prog pid="1">
>         <item iid="2" fid="11"/>
>         <item iid="3" fid="16"/>
>     </prog>
> 
>     fid attribute's value here is not important, I just want 
> to the first item element with the unique iid.
> 
>     I use the follow xsl
>     ...
>     <xsl:for-each select="//prog" order-by="@pid">
>     <xsl:for-each select="item" order-by="@iid">
>     <xsl:if exp="!checkDup( @iid )">
>     ...show the unique data...
>     </xsl:if>
>     </xsl:for-each>
>     </xsl:for-each>
>     ...
>     <xsl:script language="javascript">
>     <![CDATA[
>     var arrItemName = new Array();
> 
>     function checkDup( item )
>     {
> 	var isDup = false;
> 
> 	for ( i = 0; i&lt;arrItemName.length; i++ )
> 	{
> 		if ( arrItemName[i] == item ){
> 			isDup = true;
> 			break;
> 		}
> 	}
> 
> 	if ( isDup==false ){
> 		var len = arrItemName.length;
> 		arrItemName.length ++;
> 		arrItemName[len] = item;
> 	}
> 
> 	return isDup;
>     }
>     ]]>
>     </xsl:script>
> 
>     IE reported no error but still give the duplicate data, 
> why??? Can anyone help me out??? 
> ______________________________________
> ÎÒµÄQQ  : 329170
> ÎÒµÄICQ : 37175293
> ÎÒµÄÂÛ̳: http://www3.ccw.com.cn c/c++ 
> ===================================================================
> ÐÂÀËÃâ·Ñµç×ÓÓÊÏä (http://mail.sina.com.cn) 
> ÐÂÀË·ÖÀàÐÅÏ¢£­£­³ÇÊÐÉú»îÖ¸ÄÏ£¡ (http://classad.sina.com.cn/) 
> ÆßÖÖÊÖ»úͼƬ¡¢Ç§Ê×ÁåÉùÏÂÔØ¡­¡­ÐÂÀ˶ÌÐÅÎÞÏÞ¾«²Ê! 
> (http://sms.sina.com.cn/)
> 
>  XSL-List info and archive:  
> http://www.mulberrytech.com/xsl/xsl-list
> 
> 


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