XQUERY for loop and html



我在XMLSPY中有以下XQUERY代码,运行良好。

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>

现在我想修改如下:

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>

但它给出了语法错误。第二个代码应该完成的是,只有外部 for 循环才应该创建新行和新单元格,内部循环应该只添加到该单元格。

尝试

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>

这个XMLPLayground会话可能会对您有所帮助。它做类似的事情,即迭代表输出。

最新更新