[xquery-talk] Using Sum and Count
John Snelson
john.snelson at oracle.com
Tue Jan 15 23:26:27 PST 2008
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
> ajwei at indiana.edu
>
> _______________________________________________
> talk at x-query.com
> 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
More information about the talk
mailing list