[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:

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


PURCHASE STYLUS STUDIO ONLINE TODAY!

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.
Email
First Name
Last Name
Company
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.