I'm trying to pull a particular bit of content -- the content contained within div#content -- from a URL (http://www.inova.org/patient-and-visitor-information/facilities/inova-fair-oaks-hospital/plan-your-visit/index.jsp) . I've tried select * from html where xpath="//div[id='content']" and similar variants, but nothing is returned. The only query I've found that returns anything at all is:
select * from xml where itemPath='html.body.form'. That actually gives me the content of the form that my target div sits within, but I need to go several layers deeper where all of those layers are divs. So what I really need is an itemPath value that looks something like this:
I'm having a lot of trouble finding resources to help me construct a query using itemPath in a way that allows access to those id values. Can anyone give me a hand? There's much I'd like to understand about why other solutions, particularly the html + xpath solution won't work but for now I'd settle for just getting something in place that _does_ work. I've been battling this off and on for the better part of a week and I'm just not getting anywhere.