Hi
Running 8.5.3 on windows.
Currently open database is RaceXML1.
I am running the example from here http://docs.basex.org/wiki/Databases
for $i in 1 to 100 return db:open('books' || $i)//book/title
as
for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the database name and subsequently not found.
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found.
To new to xquery to know why this is wrong.
Full error is
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling: - pre-evaluating (1 to 100) - rewriting descendant-or-self step(s) Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan: <QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan>
Can you help?
Sayth
Hi Sayth,
for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the database name and subsequently not found.
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found.
To new to xquery to know why this is wrong.
I assume that you have no database called 'RaceXML11'. May I ask what’s the problem you want to see solved?
Christian
Full error is
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling:
- pre-evaluating (1 to 100)
- rewriting descendant-or-self step(s)
Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan:
<QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan>
Can you help?
Sayth
Well following the example on the website is broken. I would like to know how to make it work and stop it concatenating the iterable to the database name and instead just iterate as expected.
Cheers
Sayth
On Fri, 19 Aug 2016 at 21:26 Christian Grün christian.gruen@gmail.com wrote:
Hi Sayth,
for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the database
name
and subsequently not found.
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found.
To new to xquery to know why this is wrong.
I assume that you have no database called 'RaceXML11'. May I ask what’s the problem you want to see solved?
Christian
Full error is
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling:
- pre-evaluating (1 to 100)
- rewriting descendant-or-self step(s)
Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan:
<QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan>
Can you help?
Sayth
Well following the example on the website is broken.
Well as well, it isn’t broken – you obviously need databases on your system that can be opened.
I would like to know how to make it work and stop it concatenating the iterable to the database name and instead just iterate as expected.
Do you have any databases on your system that you can iterate through?
Christian
On Fri, 19 Aug 2016 at 21:26 Christian Grün christian.gruen@gmail.com wrote:
Hi Sayth,
for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the database name and subsequently not found.
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found.
To new to xquery to know why this is wrong.
I assume that you have no database called 'RaceXML11'. May I ask what’s the problem you want to see solved?
Christian
Full error is
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling:
- pre-evaluating (1 to 100)
- rewriting descendant-or-self step(s)
Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan:
<QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan>
Can you help?
Sayth
Oh it appears to not include part of my email as I psted from the website. I thought you were being odd.
for $i in 1 to 100 return db:open('books' || $i)//book/title
and I am using exactly the same but as
for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race
from here http://docs.basex.org/wiki/Databases
Sayth
On Fri, 19 Aug 2016 at 21:28 Sayth Renshaw flebber.crue@gmail.com wrote:
Well following the example on the website is broken. I would like to know how to make it work and stop it concatenating the iterable to the database name and instead just iterate as expected.
Cheers
Sayth
On Fri, 19 Aug 2016 at 21:26 Christian Grün christian.gruen@gmail.com wrote:
Hi Sayth,
for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the database
name
and subsequently not found.
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found.
To new to xquery to know why this is wrong.
I assume that you have no database called 'RaceXML11'. May I ask what’s the problem you want to see solved?
Christian
Full error is
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling:
- pre-evaluating (1 to 100)
- rewriting descendant-or-self step(s)
Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan:
<QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan>
Can you help?
Sayth
Yes RaceXML1 not the concatenated RaceXML11.
Sayth
On Fri, 19 Aug 2016 at 21:31 Sayth Renshaw flebber.crue@gmail.com wrote:
Oh it appears to not include part of my email as I psted from the website. I thought you were being odd.
for $i in 1 to 100 return db:open('books' || $i)//book/title
and I am using exactly the same but as
for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race
from here http://docs.basex.org/wiki/Databases
Sayth
On Fri, 19 Aug 2016 at 21:28 Sayth Renshaw flebber.crue@gmail.com wrote:
Well following the example on the website is broken. I would like to know how to make it work and stop it concatenating the iterable to the database name and instead just iterate as expected.
Cheers
Sayth
On Fri, 19 Aug 2016 at 21:26 Christian Grün christian.gruen@gmail.com wrote:
Hi Sayth,
for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the
database name
and subsequently not found.
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found.
To new to xquery to know why this is wrong.
I assume that you have no database called 'RaceXML11'. May I ask what’s the problem you want to see solved?
Christian
Full error is
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling:
- pre-evaluating (1 to 100)
- rewriting descendant-or-self step(s)
Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan:
<QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan>
Can you help?
Sayth
Yes RaceXML1 not the concatenated RaceXML11.
If you only have a single database, then simply address it without loop: db:open('RaceXML1').
On Fri, 19 Aug 2016 at 21:31 Sayth Renshaw flebber.crue@gmail.com wrote:
Oh it appears to not include part of my email as I psted from the website. I thought you were being odd.
for $i in 1 to 100 return db:open('books' || $i)//book/title
and I am using exactly the same but as
for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race
from here http://docs.basex.org/wiki/Databases
Sayth
On Fri, 19 Aug 2016 at 21:28 Sayth Renshaw flebber.crue@gmail.com wrote:
Well following the example on the website is broken. I would like to know how to make it work and stop it concatenating the iterable to the database name and instead just iterate as expected.
Cheers
Sayth
On Fri, 19 Aug 2016 at 21:26 Christian Grün christian.gruen@gmail.com wrote:
Hi Sayth,
for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the database name and subsequently not found.
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found.
To new to xquery to know why this is wrong.
I assume that you have no database called 'RaceXML11'. May I ask what’s the problem you want to see solved?
Christian
Full error is
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling:
- pre-evaluating (1 to 100)
- rewriting descendant-or-self step(s)
Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan:
<QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan>
Can you help?
Sayth
Ok I thought I was getting every file in the database.
Because this works
let $collect := collection("C:\Users\Sayth\Documents\Racing\XML_examples") return $collect
Compiling: - pre-evaluating collection("C:\Users\Sayth\Documents\Racing\XML_examples") - inlining $collect_0 - simplifying flwor expression Optimized Query: (db:open-pre("XML_examples",0), ...) Query: let $collect := collection("C:\Users\Sayth\Documents\Racing\XML_examples") return $collect Result: - Hit(s): 6 Items - Updated: 0 Items - Printed: 874 KB - Read Locking: global - Write Locking: none Timing: - Parsing: 0.68 ms - Compiling: 465.14 ms - Evaluating: 12.21 ms - Printing: 48.23 ms - Total Time: 526.26 ms Query plan: <QueryPlan compiled="true"> <DBNodeSeq size="6"> <DBNode name="XML_examples" pre="0"/> <DBNode name="XML_examples" pre="4555"/> <DBNode name="XML_examples" pre="11206"/> <DBNode name="XML_examples" pre="18491"/> <DBNode name="XML_examples" pre="26345"/> </DBNodeSeq> </QueryPlan>
I think I need to use $node instead.
Sayth
On Fri, 19 Aug 2016 at 21:35 Christian Grün christian.gruen@gmail.com wrote:
Yes RaceXML1 not the concatenated RaceXML11.
If you only have a single database, then simply address it without loop: db:open('RaceXML1').
On Fri, 19 Aug 2016 at 21:31 Sayth Renshaw flebber.crue@gmail.com
wrote:
Oh it appears to not include part of my email as I psted from the
website.
I thought you were being odd.
for $i in 1 to 100 return db:open('books' || $i)//book/title
and I am using exactly the same but as
for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race
from here http://docs.basex.org/wiki/Databases
Sayth
On Fri, 19 Aug 2016 at 21:28 Sayth Renshaw flebber.crue@gmail.com
wrote:
Well following the example on the website is broken. I would like to
know
how to make it work and stop it concatenating the iterable to the
database
name and instead just iterate as expected.
Cheers
Sayth
On Fri, 19 Aug 2016 at 21:26 Christian Grün <christian.gruen@gmail.com
wrote:
Hi Sayth,
for $i in 1 to 100 return db:open('RaceXML1' || $i)//meeting/race What occurs though is that the iterable is concatenated to the database name and subsequently not found.
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found.
To new to xquery to know why this is wrong.
I assume that you have no database called 'RaceXML11'. May I ask what’s the problem you want to see solved?
Christian
Full error is
Error: Stopped at C:/Users/Sayth/Documents/firstquery.xq, 2/15: [bxerr:BXDB0002] Database 'RaceXML11' was not found. Compiling:
- pre-evaluating (1 to 100)
- rewriting descendant-or-self step(s)
Optimized Query: for $i_0 in (1 to 100) return db:open(concat("RaceXML1", $i_0))/descendant::meeting/race Query: for $i in 1 to 100 return db:open("RaceXML1" || $i)//meeting/race Query plan:
<QueryPlan compiled="true"> <GFLWOR> <For> <Var name="$i" id="0"/> <RangeSeq from="1" to="100"/> </For> <CachedPath> <DbOpen name="open(database[,path])"> <FnConcat name="concat(atom1,atom2[,...])"> <Str value="RaceXML1" type="xs:string"/> <VarRef> <Var name="$i" id="0"/> </VarRef> </FnConcat> </DbOpen> <IterStep axis="descendant" test="meeting"/> <IterStep axis="child" test="race"/> </CachedPath> </GFLWOR> </QueryPlan>
Can you help?
Sayth
basex-talk@mailman.uni-konstanz.de
-
Christian Grün -
Sayth Renshaw