Hi,

I'd like to fetch part of web page with yql. I have tried several queries. Most of the queries can return the correct result except one query.

Here is the query:

select * from html where url="http://www.cngold.org/img_date/livesilvercn_rmb.html" and xpath='//div[6]/div[2]/div/div[2]/table/tbody/tr[4]/td[6]'

I hope to get the price but actually get the empty result.

How should I fix the query?

Thanks in advanced.