Mega Code Archive

 
Categories / XML / Xquery
 

Return element statement

File: Data.xml <order>   <car model="A">     <id>0001</id>     <name language="en">name 1</name>   </car>   <car model="B">     <id>0002</id>     <name language="en">name 2</name>   </car>   <car model="B">     <id>0003</id>     <name language="en">name 3</name>   </car> </order> File: Query.xquery for    $car in doc("Data.xml")//car return <car>          <id>{$car/id}</id>          <price>{for    $price in doc("Data.xml")//prod                  where  $car/id = $price/@id                  return $price/price}</price>        </car> Output: <?xml version="1.0" encoding="UTF-8"?> <car>    <id>       <id>0001</id>    </id>    <price/> </car> <car>    <id>       <id>0002</id>    </id>    <price/> </car> <car>    <id>       <id>0003</id>    </id>    <price/> </car>