|
[XQuery Talk Mailing List Archive Home] [By Date] [By Thread] [By Subject] [By Author] [Recent Entries] [Reply To This Message] XPath Issues in XQueryDavid Carlisle davidc at nag.co.ukSat Feb 16 22:33:55 PST 2008
> I hope the relationship may be a little clearer now.
a little, it appears that my previous guess was wrong, the volume and
issue are not descendants of £nodes but you do want then to depend on
this node, you just want to go up to <my> and then down again.
let $ad := (:fn:collection("xmldb:exist://db/my"):) my
let $ad2 := $ad//ad/head[contains(upper-case(.), 'MUSCLE')]
let $sorted_result:=
for $doc in distinct-values($ad2)
order by $doc
return $doc
for $r at $count in $sorted_result
let $nodes := $ad2[. = $r][1]
let $seriesStmt:=$nodes/ancestor::my//seriesStmt
return
<ad>
<statistics>
Showing Result: {$count} / {count($sorted_result)}
</statistics>
<source>
<journal>{data($seriesStmt/title[@level='journal'][1])}</journal>
<publication_information>Volume {data($seriesStmt/idno[@type='volume'][1])}, Issue {data($seriesStmt/idno[@type='issue'][1])}</publication_information>
</source>
{$nodes}
</ad>
produce this
$ saxon9q -s:alice.xml alice.xq
<?xml version="1.0" encoding="UTF-8"?>
<ad>
<statistics>
Showing Result: 1 / 1</statistics>
<source>
<journal>My Journal</journal>
<publication_information>Volume 1 , Issue 1 </publication_information>
</source>
<head type="main">FREE POWERFUL MUSCLES FAST</head>
</ad>
note I commented uput the database call and replaced it to access the
singe posted file.
David
________________________________________________________________________
The Numerical Algorithms Group Ltd is a company registered in England
and Wales with company number 1249803. The registered office is:
Wilkinson House, Jordan Hill Road, Oxford OX2 8DR, United Kingdom.
This e-mail has been scanned for all viruses by Star. The service is
powered by MessageLabs.
________________________________________________________________________
|
Purchase Stylus Studio Online Today!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! 
Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|
|
|
| Stylus Studio® Developer Network | Contact Us | Email this page |
| PRODUCTS | TRY | BUY | LEARN | SUPPORT | COMPANY |
 Cart
|
