Attempting to use a counter variable : variable « XQuery « XML






Attempting to use a counter variable


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>
  <car model="C">
    <id>0004</id>
    <name language="en">name 4</name>
  </car>
</order>

File: Query.xquery

let $count := 0
for $prod in doc("Data.xml")//car[@model = ("B", "A")]
let $count := $count + 1
return <p>{$count}. {data($prod/name)}</p>


Output:

<?xml version="1.0" encoding="UTF-8"?>
<p>1. name 1</p>
<p>1. name 2</p>
<p>1. name 3</p>

 








Related examples in the same category

1.Define variable in for statement
2.Compare value
3.Binding multiple variables in a quantified expression
4.Using a positional variable in a for clause
5.Attempting to use a positional variable with a where clause
6.Converting values with a lookup table