From e8de8b97c66a67427f4b458e2c3f3e43ea43d963 Mon Sep 17 00:00:00 2001 From: Nahuel ANGELINETTI Date: Wed, 12 Jan 2011 10:08:46 -0500 Subject: [PATCH] (bug #3743) fix acquisition stats ordering This patch fix ordering in acquisition stats to order by month number. Signed-off-by: Owen Leonard Signed-off-by: Chris Cormack --- reports/acquisitions_stats.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/reports/acquisitions_stats.pl b/reports/acquisitions_stats.pl index 045a423ae5..82201488cb 100755 --- a/reports/acquisitions_stats.pl +++ b/reports/acquisitions_stats.pl @@ -432,7 +432,7 @@ sub calculate { } } $strsth .= " GROUP BY $linefield"; - $strsth .= " ORDER BY $linefield"; + $strsth .= " ORDER BY $line"; #warn "377:strsth= $strsth"; @@ -549,7 +549,7 @@ sub calculate { $strsth2 .= " GROUP BY $colfield"; - $strsth2 .= " ORDER BY $colfield"; + $strsth2 .= " ORDER BY $column"; my $sth2 = $dbh->prepare($strsth2); -- 2.39.2