Mega Code Archive
Attempting to use a positional variable with a where clause
<![CDATA[
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 $prod at $count in doc("Data.xml")//car
where $prod/@model = ("B", "C")
order by $prod/name
return <p>{$count}. {data($prod/name)}</p>
Output:
<?xml version="1.0" encoding="UTF-8"?>
<p>2. name 2</p>
<p>3. name 3</p>
]]>