Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

XQuery/XPath problem (question)

Status
Not open for further replies.

sjurisic

MIS
Mar 17, 2005
2
CA
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top