code_junkie

how XQUERY is actually used?

Nov 10th, 2011
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. (: file: titles.xqy :)
  2. <table>
  3. <tr><th>title</th><th>author</th></tr>
  4. {
  5. let $books-doc := doc("books.xml")
  6. let $authors-doc := doc("authors.xml")
  7. for $b in $books-doc//book,
  8. $a in $authors-doc//author
  9. where $a/@id = $b/authorid
  10. return
  11. <tr>
  12. <td>{$b/title/text()}</td>
  13. <td>{$a/text()}</td>
  14. </tr>
  15. }
  16.  
  17. (: file: titles.xqy :)
  18. <table>
  19. <tr><th>title</th><th>author</th></tr>
  20. {
  21. let $books-doc := doc("books.xml")
  22. let $authors-doc := doc("authors.xml")
  23. for $b in $books-doc//book,
  24. $a in $authors-doc//author
  25. where $a/@id = $b/authorid
  26. return
  27. <tr>
  28. <td>{$b/title/text()}</td>
  29. <td>{$a/text()}</td>
  30. </tr>
  31. }
  32.  
  33. (: file: titles.xqy :)
  34. <table>
  35. <tr><th>title</th><th>author</th></tr>
  36. {
  37. let $books-doc := doc("books.xml")
  38. let $authors-doc := doc("authors.xml")
  39. for $b in $books-doc//book,
  40. $a in $authors-doc//author
  41. where $a/@id = $b/authorid
  42. return
  43. <tr>
  44. <td>{$b/title/text()}</td>
  45. <td>{$a/text()}</td>
  46. </tr>
  47. }
  48.  
  49. (: file: titles.xqy :)
  50. <table>
  51. <tr><th>title</th><th>author</th></tr>
  52. {
  53. let $books-doc := doc("books.xml")
  54. let $authors-doc := doc("authors.xml")
  55. for $b in $books-doc//book,
  56. $a in $authors-doc//author
  57. where $a/@id = $b/authorid
  58. return
  59. <tr>
  60. <td>{$b/title/text()}</td>
  61. <td>{$a/text()}</td>
  62. </tr>
  63. }
  64.  
  65. <table>
  66. <tr><td>Title<td><td>Author<td></tr>
  67. {
  68. let $authordoc := fn:doc("author.xml")
  69. for $book in fn:doc("book.xml")/books/book
  70. return
  71. <tr>
  72. <td>{ $book/title }</td>
  73. <td>{ $authordoc/authors/author/[@id eq $book/authorid] }</td>
  74. </tr>
  75. }
  76. </table>
Add Comment
Please, Sign In to add comment