我在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会话可能会对您有所帮助。它做类似的事情,即迭代表输出。