bitsummation / pickaxe

SQL Based DSL Web Scraper/Screen Scraper
Apache License 2.0
155 stars 15 forks source link

Unable to fetch multiple rows #3

Closed skanga closed 8 years ago

skanga commented 8 years ago

select pick 'p.row span.txt span.pl a' --title from download page 'https://sfbay.craigslist.org/search/mcy?minAsk=1000&maxAsk=8000&query=cruiser' where nodes = 'div.content div.rows'

Why does this query only return a single record?

breeve1 commented 8 years ago

So you need to select multiple elements in the where clause. Think array of elements. The select then selects under those. The below query works,

select pick 'span.txt span.pl a' --title from download page 'https://sfbay.craigslist.org/search/mcy?minAsk=1000&maxAsk=8000&query=cruiser' where nodes = 'div.content div.rows p'

skanga commented 8 years ago

Thanks. That works.