XQUERY for loop and html

Question

I have the following XQUERY code in XMLSPY which runs fine.

xquery version "1.0";

<table border="1">
{
 for $re in distinct-values(reviews/review/reviewer)
 for $r in reviews/review
 where $re=$r/reviewer
 return  <tr> <td>{$r/movie_title}</td> </tr>
}
</table>

Now I want to modify it as follows :

xquery version "1.0";

<table border="1">
{
 <tr> <td>
 for $re in distinct-values(reviews/review/reviewer)
 for $r in reviews/review
 where $re=$r/reviewer
 return  {$r/movie_title}
 </td> </tr>
}
</table>

But it gives syntax error. What the second code should accomplish is that only outer for loop should create new row and new cell and inner loop should only add to that cell.

Mitya · Accepted Answer · 2012-11-17 08:54:10Z

1

Try

for $re in distinct-values(reviews/review/reviewer) return <tr>{
    for $r in reviews/review
        where $re=$r/reviewer
            return <td>{$r/movie_title}</td>
}</tr>

This XMLPLayground session might help you. It does something similar, i.e. iterative table output.

answered Nov 17, 2012 at 8:54

Mitya

34.8k15 gold badges70 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

aditya parikh Over a year ago

Modifying your code for what I want brought me closer to this :

<table border="1">  { for $re in distinct-values(reviews/review/reviewer) return <tr><td>{     for $r in reviews/review         where $re=$r/reviewer             return ($r/movie_title) }</td></tr> } </table>

But I want comma between each return statement

aditya parikh Over a year ago

Where should I put the comma ?

Mitya Over a year ago

Why would you want a comma between your td tags? This would lead to invalid HTML.

Collectives™ on Stack Overflow

XQUERY for loop and html

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related