Using Sum and Count [SEC=UNCLASSIFIED]

[Nicholas.Ardlie at ga.gov.au]

Is is that you want the count of all children of the projection nodes? E.g.

count(doc("http://chausie.slis.indiana.edu:8080/exist/rest//db/resume/resume.
xml")//projection/child::*)

Or maybe all descendents? E.g.

count(doc("http://chausie.slis.indiana.edu:8080/exist/rest//db/resume/resume.
xml")//projection/descendant::*)

Nick.

-----Original Message-----
From: http://x-query.com/mailman/listinfo/talk [mailto:http://x-query.com/mailman/listinfo/talk] On Behalf Of
John Snelson
Sent: Wednesday, 16 January 2008 10:26 AM
To: Wei, Alice J.
Cc: http://x-query.com/mailman/listinfo/talk
Subject: Re:  Using Sum and Count

Hi Alice,

You are iterating over the nodes in $project//projection, binding each 
one in turn to $head. So your query is quite right in telling you that 
$head contains 1 item!

You probably want something like this:

count(doc("http://chausie.slis.indiana.edu:8080/exist/rest//db/resume/resume.
xml")//projection)

John

Wei, Alice J. wrote:
> Hi, XQueriers:
> 
>   I have an XML here as follows:
> 
> <project>
> 
> <projection><!--More Markup--></projection>
> <projection><!--More Markup--></projection>
> <!--More markup-->
> </project>
> 
> My XQuery:
> 
> declare boundary-space preserve;
> 
> for $project in
>
doc("http://chausie.slis.indiana.edu:8080/exist/rest//db/resume/resume.xml"),
> $head in $project//projection
> return
> <statistics>sum({count($head)})</statistics>
> 
> I intend to get the result of how many items in <projection>, but when I
execute it, it only gives me lots and lots of <statistics>sum(1)</statistics>
> until the document is finished.
> 
> Can any expert out there help me out and tell me what is the matter with my
code?
> 
> Thanks to those who can help.
> 
> Alice.
> 
> ======================================================
> Alice Wei
> MIS 2008
> School of Library and Information Science
> Indiana University Bloomington
> http://x-query.com/mailman/listinfo/talk
> 
> _______________________________________________
> http://x-query.com/mailman/listinfo/talk
> http://x-query.com/mailman/listinfo/talk


-- 
John Snelson, Oracle Corporation
Berkeley DB XML:        http://www.oracle.com/database/berkeley-db/xml
XQilla:                                  http://xqilla.sourceforge.net
_______________________________________________
http://x-query.com/mailman/listinfo/talk
http://x-query.com/mailman/listinfo/talk