Thank you, it works :)What about the error? error: [XPTY0019] descendant::subj: node expected, xs:boolean found: false().Any idea please?
De : Maximilian Gärber mgaerber@arcor.de À : Mohamed kharrat med_khr@yahoo.fr Cc : BaseX Talk basex-talk@mailman.uni-konstanz.de Envoyé le : Mardi 19 juillet 2016 17h44 Objet : Re: [basex-talk] querying database
Hi,
you do not need to use doc() or collection() if your documents are stored in a database.
The documents are just nodes as well, so doing something like:
let $db := db:open('some-db') for $d in $db//item/@qcode="tx" return $d
would return the items from all nodes (all files)
BTW: I guess you want: $db// item[@qcode="tx"]
Regards, Max
2016-07-19 18:33 GMT+02:00 Mohamed kharrat med_khr@yahoo.fr:
Hi, i have created a database in BaseX GUI but i did not understand how to use it inside FLWR query. So since i would like to create one FLWR query to query all my files in the database not only one file with doc() i have tried collection() is that right? (i have putted all my xml files inside path/ directory) This is my query:
let $d:= collection ("path/") let $r:= doc("myfile1.xml") for $d in $d// item/@qcode="tx" where $d//subj[text() contains text { 'Hal', 'Fade' } any] and $r/subj ="Berlin" return <results>$d/tit</results>
it shows me error: [XPTY0019] descendant::subj: node expected, xs:boolean found: false().
what is that error about?
Thank you Best regards