diff options
author | ivan <ivan> | 2012-02-15 05:17:22 +0000 |
---|---|---|
committer | ivan <ivan> | 2012-02-15 05:17:22 +0000 |
commit | a7edb84851d2238c7ec449483f5bd34e40813ccd (patch) | |
tree | 69cf08516e767f3da22816009919936ab03e61ac | |
parent | c6e4f9460f44a7440ef2fa7e67ed51dfe40a7668 (diff) |
fix 477 VI
-rwxr-xr-x | httemplate/search/477partVI_census.html | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/httemplate/search/477partVI_census.html b/httemplate/search/477partVI_census.html index 51baef7..3883a1c 100755 --- a/httemplate/search/477partVI_census.html +++ b/httemplate/search/477partVI_census.html @@ -126,11 +126,13 @@ foreach my $row ( @row_option ) { my $count_query = 'SELECT count(*) FROM ( ('. join( ') UNION ALL (', - map { my $extra = $_->{extra_sql}; my $addl = $_->{addl_from}; - "SELECT censustract from cust_pkg $addl $extra"; - } - @sql_query - ). ') ) AS foo'; + map { my $addl_from = $_->{addl_from}; + my $extra_sql = $_->{extra_sql}; + my $order_by = $_->{order_by}; + "SELECT censustract from cust_pkg $addl_from $extra_sql $order_by"; + } + @sql_query + ). ') ) AS foo'; my $link = 'cust_pkg.cgi?'. join(';', map { my $key = $_; |