pricecharts

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

commit 4b1583ce164ee77173f03f8f707e2e0d46d00223
parent 2be83e41000efd5bcda065da5d28c5f2f48f9cba
Author: Kyle Milz <kyle@getaddrinfo.net>
Date:   Sat, 21 Mar 2015 16:11:23 -0600

gen_static: correct for different manufacturer capitalization

Diffstat:
Mgen_static | 4++--
1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/gen_static b/gen_static @@ -34,8 +34,8 @@ my $template = Template->new($config) || die Template->error() . "\n"; # manufacturers.html, manufacturers/* -my $manufacturers_sql = "select distinct manufacturer from products"; -my $parts_sql = "select part_num, lower(manufacturer), description from products where manufacturer = ?"; +my $manufacturers_sql = "select distinct lower(manufacturer) from products"; +my $parts_sql = "select part_num, lower(manufacturer), description from products where lower(manufacturer) = ?"; my $m = gen_link_page($manufacturers_sql, $parts_sql, "manufacturers", "Manufacturers"); # retailers.html, retailers/*