<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoPlainText, li.MsoPlainText, div.MsoPlainText
{mso-style-priority:99;
mso-style-link:"Plain Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.5pt;
font-family:Consolas;}
span.PlainTextChar
{mso-style-name:"Plain Text Char";
mso-style-priority:99;
mso-style-link:"Plain Text";
font-family:Consolas;}
.MsoChpDefault
{mso-style-type:export-only;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>Hi,
Michael:<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>
Sorry, but that is not entirely what I want. I was hoping to not just keep the
information but also the markup. Is there some way I can do that?<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'> This
means that I should not be using distinct-values() because it is similar to
<xsl:value-of select=""> as in XSLT, right?<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>Here is
the code again:<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>declare
boundary-space preserve;<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><book><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>{<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>let
$sorted_result:= for $doc in<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>distinct-values((doc("1.xml"),doc("3.xml"),<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>doc("4.xml"),
doc("2.xml"))//ad/p/address)<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>order by
$doc ascending<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>return $doc<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>for
$sorted_results at $count in $sorted_result<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>return<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><bibl><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><statistics>Showing
Result: {$count} / {count($sorted_result)}<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'></statistics><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>{$sorted_result}<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'></bibl><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>}<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'></book><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>Thanks
for your help.<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>======================================================<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>Alice
Wei<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>MIS 2008<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>School
of Library and Information Science<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'>Indiana
University Bloomington<o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><a
href="mailto:ajwei@indiana.edu">ajwei@indiana.edu</a><o:p></o:p></span></p>
<p class=MsoPlainText><span style='font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoPlainText>-----Original Message-----<br>
From: Michael Kay [mailto:mike@saxonica.com] <br>
Sent: Monday, January 21, 2008 4:04 PM<br>
To: Wei, Alice J.; 'Liam Quin'<br>
Cc: talk@x-query.com<br>
Subject: RE: [xquery-talk] Query Through Multiple Files<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>> I tried using<o:p></o:p></p>
<p class=MsoPlainText>> distinct-values(doc("1.xml"),
doc("3.xml"), doc("4.xml"),<o:p></o:p></p>
<p class=MsoPlainText>> doc("2.xml"))//title, but I got the error
that there should<o:p></o:p></p>
<p class=MsoPlainText>> be only 2 arguments.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>You didn't read my example carefully enough<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>distinct-values(( doc("1.xml"),<o:p></o:p></p>
<p class=MsoPlainText> doc("2.xml"),<o:p></o:p></p>
<p class=MsoPlainText> doc("3.xml"),<o:p></o:p></p>
<p class=MsoPlainText> doc("4.xml"))//ad)<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Firstly, you want to find the set of titles and then take
the distinct<o:p></o:p></p>
<p class=MsoPlainText>values in this set: so the "//title" part needs
to inside the argument to<o:p></o:p></p>
<p class=MsoPlainText>distinct-values(). The way you've written it, you're
taking four documents,<o:p></o:p></p>
<p class=MsoPlainText>then eliminating duplicates, then taking the title
elements within those<o:p></o:p></p>
<p class=MsoPlainText>that are left.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Secondly, if you supply a sequence to a function that
expects a single<o:p></o:p></p>
<p class=MsoPlainText>argument then you need to double the parentheses, for
example<o:p></o:p></p>
<p class=MsoPlainText>sum((1,2,3,4,5)) or distinct-values((1,2,2,4,4)). That's
to make it clear<o:p></o:p></p>
<p class=MsoPlainText>you are passing one argument which is a sequence of five
integers, not five<o:p></o:p></p>
<p class=MsoPlainText>arguments that are single integers. IN your case you've
called<o:p></o:p></p>
<p class=MsoPlainText>distinct-values() with four arguments, rather than with a
single argument<o:p></o:p></p>
<p class=MsoPlainText>that is a sequence.<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText>Michael Kay<o:p></o:p></p>
<p class=MsoPlainText>http://www.saxonica.com/<o:p></o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
<p class=MsoPlainText><o:p> </o:p></p>
</div>
</body>
</html>