MySQL Forums
Forum List  »  Connector/Node.js

Re: try to get html with ectract value - but fails
Posted by: Hartmut Holzgraefe
Date: March 09, 2010 12:46AM

> mysql> select length(html), ExtractValue(html,
> '/html/head/title') from static_h
> tml where html is not null limit 1;
> +--------------+----------------------------------
> ------+
> | length(html) | ExtractValue(html,
> '/html/head/title') |
> +--------------+----------------------------------
> ------+
> | 63453 | NULL
> |
> +--------------+----------------------------------
> ------+
> 1 row in set, 1 warning (0.00 sec)

Do a SHOW WARNINGS at this point to see what the actual warning raised was.

From looking at the pages HTML content the problem is most likely that it is not valid XML (unclosed comments, unclosed tags ...)

Hartmut Holzgraefe, MySQL Regional Support Manager EMEA

Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering

Options: ReplyQuote

Written By
Re: try to get html with ectract value - but fails
March 09, 2010 12:46AM

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.