MySQL Forums
Forum List  »  Connector/Node.js

Re: Help with ExtractValue
Posted by: Thomas Bhatia
Date: January 18, 2009 03:37PM

Figured it out.

Because ExtractValue won't let you select <HOME/> or <WORK/> subnode, and doing "select extractvalue(vcard, '//ADR/REGION') from ofVCard;" gets both the values Dorset and London, doing "select extractvalue(vcard, '//ADR[1]/REGION') from ofVCard;" gets the 1st value Dorset and [2] gets the 2nd London.

It's a wonder what a good cup of espresso can do :)

Options: ReplyQuote

Written By
January 18, 2009 10:54AM
Re: Help with ExtractValue
January 18, 2009 03:37PM
February 18, 2009 02:07AM

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.