MySQL Forums
Forum List  »  Connector/Node.js

extractvalue issue
Posted by: Anoop Sharda
Date: January 24, 2009 01:32AM

hi

we have the following xml structure

<section>
<title>Choosing an Install Package</title>
<para>...three different packages...</para>
<itemizedlist>
<listitem id=”1”>
<para><literal>....noinstall.zip</literal>: ...Zip archive....</para>
</listitem>
<listitem id=”full”>
<para><literal>...win.zip</literal>: ...full installation with all optional packages...</para>
</listitem>
<listitem id=”essential”>
<para><literal>...win.msi</literal>: ...minimum components...</para>
</listitem>
</itemizedlist>
<para>...win.msi...package is recommended...because of its smaller size.</para>
</section>

When we give following query, no value is returned, we just get blank rows.

select extractValue(test, '/section/itemizedlist/listitem[@id="1"]/para/literal') from testdb

is there something we are doing wrong?

Anoop

Options: ReplyQuote


Subject
Written By
Posted
extractvalue issue
January 24, 2009 01:32AM
February 18, 2009 01:08AM


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.