[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message]

Using Sum and Count

John Snelson john.snelson at oracle.com
Tue Jan 15 23:26:27 PST 2008

  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:



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


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.