MySQL Forums
Forum List  »  Connector/Node.js

unexpected result in ExtractValue
Posted by: Dimitris Kounalakis
Date: July 04, 2006 12:00PM

I issue the following query:
select dat,zot,ExtractValue(zot,"/zot/tim0/02") from encs

where zot's content is:
<zot>
<tim0>
<01>10:39:15</01>
<02>140</02>
<03>90</03>
</tim0>
<tim1>
<01>12:19:10</01>
<02>149</02>
<03>100</03>
</tim1>
</zot>

I expected to have "140" as result but I get "2"

is that normal?

Options: ReplyQuote


Subject
Written By
Posted
unexpected result in ExtractValue
July 04, 2006 12:00PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.