Hi All,
This is XQuery/XPath question and I spent a lots of time searching the web - and could not figure it out;
My query:
let $m := //bookkeeping[@date[contains(.,'200503')]]//record/@billed
return
$m
returns proper results; However, results includes both numbers and empty tags (whitespace)
If I do:
let $m := //bookkeeping[@date[contains(.,'200503')]]//record/@billed
return
sum($m)
I have an exception:
"An exception occurred during query execution: cannot convert string ''into a double"
How to work around it?
MANY THANKS,
Sava
This is XQuery/XPath question and I spent a lots of time searching the web - and could not figure it out;
My query:
let $m := //bookkeeping[@date[contains(.,'200503')]]//record/@billed
return
$m
returns proper results; However, results includes both numbers and empty tags (whitespace)
If I do:
let $m := //bookkeeping[@date[contains(.,'200503')]]//record/@billed
return
sum($m)
I have an exception:
"An exception occurred during query execution: cannot convert string ''into a double"
How to work around it?
MANY THANKS,
Sava