Databases
StackOverflow2013
Postsdbo
POXPath query in Google docs does not match HTML source
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POXPath query in Google docs does not match HTML source
    primarykey
    data
    text
    <p>Using <a href="http://www.xpathbuilder.com/" rel="nofollow">XpathBuilder</a> I can construct a simple search engine query and pull data out of the search results using XPath. I have some simple examples in a Google Doc spreadsheet <a href="https://docs.google.com/spreadsheet/ccc?key=0AtT1QPEACWUldE9CZno5WkhzVGZBXzhaMjdNc045Z3c" rel="nofollow">here</a>, which runs the query "XPath tutorial" on various search engines and attempts to pull out the number of results each search engine returns. </p> <p>The code in that Google Doc is as follows:</p> <pre><code>=importxml("http://www.google.com/search?q="xpath+tutorial"&amp;num=30&amp;pws=0", "//div[@id='resultStats']") =importxml("http://www.bing.com/search?q=xpath+tutorial&amp;count=30", "//span[@class='sb_count']") =importxml("http://search.yahoo.com/search?p=xpath+tutorial&amp;n=30", "//span[@id='resultCount']") </code></pre> <p>There are some oddities about this that I don't understand. Firstly, the Google search does not return any results, but the XPath query looks OK. Indeed, there are a number of online tutorials which recommend exactly what I have done here.</p> <p>The Yahoo query returns the correct result, it's the only one that does.</p> <p>The number of results found by the Bing Xpath query do not match the results given on the <a href="http://www.bing.com/search?q=xpath+tutorial&amp;count=30" rel="nofollow">Bing web page</a>, even though there is only one XML node which matches the XPath query. More details are on the <a href="https://docs.google.com/spreadsheet/ccc?key=0AtT1QPEACWUldE9CZno5WkhzVGZBXzhaMjdNc045Z3c" rel="nofollow">spreadsheet here</a></p> <p>Where did it all go so wrong?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USsnim2
    1. USsnim2
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POXPath query in Google docs does not match HTML source
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POXPath query in Google docs does not match HTML source
      1. This table or related slice is empty.
      1. VTDownMod
    1. CODownvoting because no code is shown.
      singulars
      1. POXPath query in Google docs does not match HTML source
      1. USMichael Kay
    2. COThe code was all in the Google Doc which also showed the results and gave some details of the source code from the search engines. I've added some of this to the question now.
      singulars
      1. POXPath query in Google docs does not match HTML source
      1. USsnim2
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload