pricecharts

track prices of consumer electronics
Log | Files | Refs | README

commit 2509d33a725cbf407e87539507f80dc83aa52ef3
parent d2ac9667bffb2d99627935b0d1021541b85b477d
Author: Kyle Milz <kyle@getaddrinfo.net>
Date:   Mon,  3 Nov 2014 20:37:52 -0700

price_scraper: only select a row

Diffstat:
Mprice_scraper.pl | 2+-
1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/price_scraper.pl b/price_scraper.pl @@ -14,7 +14,7 @@ if ($args{p}) { } else { my $cutoff = time - (30 * 24 * 60 * 60); - my $results = $dbh->selectcol_arrayref("select part_num from products " . + my $results = $dbh->selectrow_arrayref("select part_num from products " . "where last_seen > $cutoff order by last_scraped asc"); if (! @$results) { print "Product table empty, run product_scraper.pl\n";