diff options
Diffstat (limited to 'editcomponents.cgi')
| -rwxr-xr-x | editcomponents.cgi | 21 |
1 files changed, 12 insertions, 9 deletions
diff --git a/editcomponents.cgi b/editcomponents.cgi index a8d1f1f90..9a1e7934e 100755 --- a/editcomponents.cgi +++ b/editcomponents.cgi @@ -139,8 +139,9 @@ unless ($product) { if ($showbugcounts){ SendSQL("SELECT products.name, products.description, COUNT(bug_id) - FROM products LEFT JOIN bugs ON products.id = bugs.product_id - GROUP BY products.name + FROM products LEFT JOIN bugs + ON products.id = bugs.product_id " . + $dbh->sql_group_by('products.name', 'products.description') . " ORDER BY products.name"); } else { SendSQL("SELECT products.name, products.description @@ -184,17 +185,19 @@ unless ($action) { my @components = (); if ($showbugcounts) { - SendSQL("SELECT name,description, initialowner, + SendSQL("SELECT name, description, initialowner, initialqacontact, COUNT(bug_id) - FROM components LEFT JOIN bugs ON - components.id = bugs.component_id - WHERE components.product_id = $product_id - GROUP BY name"); + FROM components LEFT JOIN bugs + ON components.id = bugs.component_id + WHERE components.product_id = $product_id " . + $dbh->sql_group_by('name', + 'description, initialowner, initialqacontact')); } else { SendSQL("SELECT name, description, initialowner, initialqacontact FROM components - WHERE product_id = $product_id - GROUP BY name"); + WHERE product_id = $product_id " . + $dbh->sql_group_by('name', + 'description, initialowner, initialqacontact')); } while (MoreSQLData()) { |