ansaurus

Question

What is the syntax error in this xquery script?

Answer 1

+1 A:

You forgot a <OL> before the { on line 9.

So it should be:

<HTML>
<HEAD><TITLE>Alphabetical Cities Lists</TITLE></HEAD>
<BODY>
{
  for $indcode in (65 to 70)
  let $indlet := codepoints-to-string($indcode)
  return 
     <H1> {$indlet} LIST </H1>
     <OL>
     {
       for $cit in doc("mydoc.xml")/CITIES/ENTITY
       where starts-with($cit/NAME,$indlet)
       order by $cit/NAME
       return <LI>{$cit/NAME}</LI>
     }
     </OL>
} 
</BODY>
</HTML>

Johannes Jensen 2010-06-21 16:32:11

Thanks, you're right, I did. But that still leaves the syntax error.

BigBeagle 2010-06-21 16:39:43

Answer 2

+2 A:

This is a common mistake.

You need to place a , between the <H1> and <OL> nodes.

A single node is an XQuery expression (as are multiple nodes inside a direct element constructor). The return expression must be an expression. In this case you want to return two nodes. Each node is a single item and so in order to return them both you need to concatenate the two nodes in a sequence.

The query would look like this:

<HTML>
<HEAD><TITLE>Alphabetical Cities Lists</TITLE></HEAD>
<BODY>
{
  for $indcode in (65 to 70)
  let $indlet := codepoints-to-string($indcode)
  return 
     (<H1> {$indlet} LIST </H1>,
     <OL>
     {
       for $cit in doc("mydoc.xml")/CITIES/ENTITY
       where starts-with($cit/NAME,$indlet)
       order by $cit/NAME
       return <LI>{$cit/NAME}</LI>
     }
     </OL>)
} 
</BODY>
</HTML>

Oliver Hallam 2010-06-21 17:05:57

Thank you very much. This is exactly what I needed. And thanks for the detailed explanation.

BigBeagle 2010-06-21 17:38:28

ansaurus

tags:

views:

answers:

What is the syntax error in this xquery script?

related questions