XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Bilbo BagginsSubject: Problem getting distinct values
Author: Bilbo Baggins
Date: 11 May 2007 09:04 AM
I'm just having a few problems some distinct results from my query.

I have an xml document that looks something like this -

<doc>
<a>
<row>
<aa>A1</aa>
<aaa>A2</aaa>
</row>
</a>
<b>
<row>
<aa>A1</aa>
<aa>A2</aa>
<cc>C2</cc>
<cc>C1</cc>
<dd>D1</dd>
</row>
</b>
<c>
<row>
<cc>C1</cc>
</row>
</c>
<d>
<row>
<dd>D1</dd>
<ddd>D2</ddd>
<dddd>D3</dddd>
<ddddd>D4</ddddd>
<aa>A1</aa>
<aa>A2</aa>
</row>
</d>
</doc>

And my query looks something like this -

<result>
{
for
$doc in doc("doc.xml")/doc,
$a in $doc/a/row,
$b in $doc/b/row,
$c in $doc/c/row,
$d in $doc/d/row
where
$d/aa/text() = $a/aa/text() and
$d/dd/text() = $b/dd/text() and
$b/cc/text() = $c/cc/text()
return
<e>
{$d/dd}
{$d/ddd}
{$d/dddd}
{$d/ddddd}
{$a/aaa}
</e>

}
</result>

But I do, of course, get multiple results. What I can't work out is how to filter out distinct results, after all the 'joins' have been done in the where section. Can anyone help me out?

Posttop
Alberto MassariSubject: Problem getting distinct values
Author: Alberto Massari
Date: 14 May 2007 04:21 PM
Hi Bilbo (where is Frodo??)
you will have to use distinct-values, like in this thread http://www.stylusstudio.com/SSDN/default.asp?action=9&read=6382&fid=57

Hope this helps,
Alberto

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.