MySQL Forums
Forum List  »  Connector/Node.js

Error parsing processing instructions
Posted by: mike leber
Date: March 23, 2009 04:08AM

I try to extract a value from a blob field called xmlfield but i get always
following error message.

select uuid,extractvalue (xmlfield ,'/feedback/contact/name')FROM FORM J

Incorrect XML value: 'parse error at line 2 pos 21: unknown token unexpected (ident or string wanted)'

After removing the processing instructions all works fine! Is there a way to disaple parsing of processing instructions?


kind regards

XML Data

<?xml version="1.0" encoding="UTF-8"?>
<?jaxfront version=2.50;time=2008-10-13 11:23:04.219;MANDANT_ID=5;SEQUENCE_ID=DEMO-FEEDBACK-2;LASTUPDATE=2008-10-13T11:23:04.212Z;STATUS=2;FORM_ID=DEMO-FEEDBACK;pid=2;LAST_UPDATE=2008-10-13T11:23:04.132Z;SENDER_EMAIL=spo@jaxfront.com;ID=EC3DC0EF178A48567F5540FA7DA6F0D5;CREATED=2008-10-13T11:23:04.212Z;OWNER=17;GROUP_ID=9;NAME=Demo Public Feedback Form?>
<feedback xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">;
<contact>
<name>asdf</name>
<email>spo@jaxfront.com</email>
<role/>
</contact>
<usage>
<usageAtYourPlace>false</usageAtYourPlace>
</usage>
<reply/>
</feedback>

Options: ReplyQuote


Subject
Written By
Posted
Error parsing processing instructions
March 23, 2009 04: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.