[xquery-talk] Count a specific word in a document

[Bas de Bakker]

Michael Kay wrote:

> In fact the use of /text() is very common in XQuery circles, and in my view
> it's usually wrong. You nearly always want the string value of the element
> rather than its text node children: /string() rather than /text(), except as
> I say that it's usually implicit.

Indeed, which allows me to return to one of my pet peeves: bad examples 
in the XQuery Use Cases document, which many people use as examples. In 
this case, we read:

1.1.9.9 Q9

In the document "books.xml", find all section or chapter titles that 
contain the word "XML", regardless of the level of nesting.

Solution in XQuery:

<results>
   {
     for $t in doc("books.xml")//(chapter | section)/title
     where contains($t/text(), "XML")
     return $t
   }
</results>

Regards,
Bas de Bakker