Databases
StackOverflow2013
Postsdbo
POWhat is the syntax error in this xquery script?
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POWhat is the syntax error in this xquery script?
    text
    copied!<p>I'm a beginner to XQuery, trying to do some simple exercises to learn it. But this latest query I'm trying to put together refuses to run, giving me a syntax error.</p> <p>This is my XQuery:</p> <pre><code>&lt;HTML&gt; &lt;HEAD&gt;&lt;TITLE&gt;Alphabetical Cities Lists&lt;/TITLE&gt;&lt;/HEAD&gt; &lt;BODY&gt; { for $indcode in (65 to 70) let $indlet := codepoints-to-string($indcode) return &lt;H1&gt; {$indlet} LIST &lt;/H1&gt; { for $cit in doc("mydoc.xml")/CITIES/ENTITY where starts-with($cit/NAME,$indlet) order by $cit/NAME return &lt;LI&gt;{$cit/NAME}&lt;/LI&gt; } &lt;/OL&gt; } &lt;/BODY&gt; &lt;/HTML&gt; </code></pre> <p>And this is a subset of my XML file mydoc.xml:</p> <pre><code>&lt;CITIES&gt; &lt;ENTITY&gt; &lt;NAME&gt;Hastings&lt;/NAME&gt; &lt;CITYCOD&gt;230&lt;/CITYCOD&gt; &lt;CNTYCOD&gt;01&lt;/CNTYCOD&gt; &lt;/ENTITY&gt; &lt;ENTITY&gt; &lt;NAME&gt;Tilden&lt;/NAME&gt; &lt;CITYCOD&gt;487&lt;/CITYCOD&gt; &lt;CNTYCOD&gt;02&lt;/CNTYCOD&gt; &lt;/ENTITY&gt; &lt;ENTITY&gt; &lt;NAME&gt;Alliance&lt;/NAME&gt; &lt;CITYCOD&gt;008&lt;/CITYCOD&gt; &lt;CNTYCOD&gt;07&lt;/CNTYCOD&gt; &lt;/ENTITY&gt; &lt;ENTITY&gt; &lt;NAME&gt;Hemingford&lt;/NAME&gt; &lt;CITYCOD&gt;236&lt;/CITYCOD&gt; &lt;CNTYCOD&gt;07&lt;/CNTYCOD&gt; &lt;/ENTITY&gt; &lt;ENTITY&gt; &lt;NAME&gt;Ainsworth&lt;/NAME&gt; &lt;CITYCOD&gt;003&lt;/CITYCOD&gt; &lt;CNTYCOD&gt;09&lt;/CNTYCOD&gt; &lt;/ENTITY&gt; &lt;ENTITY&gt; &lt;NAME&gt;Kearney&lt;/NAME&gt; &lt;CITYCOD&gt;269&lt;/CITYCOD&gt; &lt;CNTYCOD&gt;10&lt;/CNTYCOD&gt; &lt;/ENTITY&gt; &lt;ENTITY&gt; &lt;NAME&gt;Oakland&lt;/NAME&gt; &lt;CITYCOD&gt;358&lt;/CITYCOD&gt; &lt;CNTYCOD&gt;11&lt;/CNTYCOD&gt; &lt;/ENTITY&gt; &lt;ENTITY&gt; &lt;NAME&gt;Eagle&lt;/NAME&gt; &lt;CITYCOD&gt;159&lt;/CITYCOD&gt; &lt;CNTYCOD&gt;13&lt;/CNTYCOD&gt; &lt;/ENTITY&gt; &lt;/CITIES&gt; </code></pre> <p>What I want it to do is print out a simple HTML document with several lists of these city names, broken out by the letter they start with (A to F).</p> <p>But when I try running this out on <a href="http://try.zorba-xquery.com/" rel="nofollow noreferrer">this site</a>, it gives me this error:</p> <p><strong>Query: &lt;>, line 9, column 6: [XPST0003] syntax error, unexpected "'{'", expecting "'}'"</strong> </p> <p>I have no idea why it says that. I've checked and checked, but my curly braces all seem properly matched. Can anyone see what the problem is? Thanks.</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload